Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone
I am trying to write two formulas
one That will bring me the change in percentages and one in money
I'm not getting the right numbers,
Would appreciate help
Attaches the formulas
Solved! Go to Solution.
@netanel ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
The two need to measures no column
Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]
Try for a second one
Net USD LM % difference from Net USD average per Day1 =
VAR __BASELINE_VALUE = [Net USD average per Day]
VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
RETURN
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
@netanel ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
The two need to measures no column
Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]
Try for a second one
Net USD LM % difference from Net USD average per Day1 =
VAR __BASELINE_VALUE = [Net USD average per Day]
VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
RETURN
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |