
Dernière_Année = 
IF(
    'Calendrier'[Année] = CALCULATE(MAX('Calendrier'[Année]), ALL('Calendrier')),
    1,
    0
)


_________________________________

Actif_Circulant = 
CALCULATE (
    SUM ( Bilan[Montant_Cloture] ),
    Bilan[Rubrique] IN {
        "actif circulant"
    }
)


_________________________________

Passif_Circulant = 
CALCULATE (
    SUM ( Bilan[Montant_Cloture] ),
    Bilan[Rubrique] IN {
        "Passif circulant"
    }
)


_________________________________

Ratio_LG = 
// ratio de liquidité générale
DIVIDE ( [Actif_Circulant], [Passif_Circulant] )


_________________________________

Stock =
CALCULATE (
    SUM ( Bilan[Montant_Cloture] ),
    Bilan[Famille_Bilan] = "Stocks"
)


_________________________________

Actif_Circ_hors_Stock = 
[Actif_Circulant] - [Stock]


_________________________________

Ratio_LR = 
// Ratio de liquidité réduite 
DIVIDE ( [Actif_Circ_hors_Stock], [Passif_Circulant] )


_________________________________

Capitaux_Propres = 
CALCULATE (
    SUM ( Bilan[Montant_Cloture] ),
    Bilan[Sens] IN { "Passif" },
    Bilan[Famille_Bilan] IN { "Capitaux_Propres" }
)


_________________________________

Total_Bilan = 
CALCULATE (
    SUM ( Bilan[Montant_Cloture] ),
    Bilan[Sens] IN { "Passif" }
)


_________________________________

Ratio_AF = 
// Ratio d’autonomie financière
DIVIDE ( [Capitaux_Propres], [Total_Bilan])



_________________________________

Dettes_Financieres =
CALCULATE (
    SUM ( Bilan[Montant_Cloture] ),
    Bilan[Famille_Bilan] IN { "Dettes_Financieres_CT", "Dettes_Financieres_LT" }
)


_________________________________

Ratio_EF =
// Ratio d’endettement financier
DIVIDE ( [Dettes_Financieres], [Capitaux_Propres] )



_________________________________





_________________________________









