The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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)
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |