Skip to content

Instantly share code, notes, and snippets.

@hdary85
Created February 1, 2024 05:04
Show Gist options
  • Save hdary85/a8ac10b74d3fe8b20043777caf7efabe to your computer and use it in GitHub Desktop.
Save hdary85/a8ac10b74d3fe8b20043777caf7efabe to your computer and use it in GitHub Desktop.
Taux_Variation_MNE =
CALCULATE(
(
SUMX(
VALUES('PBI'[MNE]),
(CALCULATE(SUM('PBI'[Montant]), 'PBI'[Semestre] = 2) -
CALCULATE(SUM('PBI'[Montant]), 'PBI'[Semestre] = 1)) /
CALCULATE(SUM('PBI'[Montant]), 'PBI'[Semestre] = 1)
)
),
ALLEXCEPT('PBI', 'PBI'[MNE])
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment