Untitled

Anonymous
plain_text
07/23/2023 6:53 PM
544 B
13
Indexable
Montant HT EUR =
IF (
    '01 ENCOURS'[Facture] = "X",
    IF (
        '01 ENCOURS'[Devise] <> "",
        '01 ENCOURS'[Montant HT]
            / RELATED ( Taux[Taux Budget] ),
        '01 ENCOURS'[Montant HT]
    ),
    IF (
        '01 ENCOURS'[Devise] <> "",
        '01 ENCOURS'[Montant HT]
            / RELATED ( Taux[Taux Budget] ) * -1,
        '01 ENCOURS'[Montant HT] * -1
    )
)
Editor is loading...