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.
Hi there!
I am looking for some help with my dax:
I have a very simplified dataset and I want to calculate the percent difference (V2-V1)/V1 . I would like a way to calculate the percent difference based off of different reference values: AVGstatic, AVGmonthly (calculated). I would only like to have 1 column called 'Percent difference' , but I don't know how to filter the table properly.
Thank you for your help.
Corey
OUTPUT:
AVGstatic = 6
TABLE 1:
Date | Bananas Eaten | Percent difference |
1.1.2024 | 6 | 0 |
1.2.2024 | 7 | 17% |
1.3.2024 | 8 | 33% |
AVGMonthly = 10
TABLE 1:
Date | Bananas Eaten | Percent difference |
1.1.2024 | 6 | -40% |
1.2.2024 | 7 | -30% |
1.3.2024 | 8 | -20% |
Solved! Go to Solution.
Hi @Anonymous ,
You can try dax like below:
M1 =
VAR cur =
IF (
NOT ISBLANK ( SELECTEDVALUE ( slice[tag] ) ),
SELECTEDVALUE ( slice[value] ),
BLANK ()
)
RETURN
( MAX ( 'Table'[Bananas Eaten] ) - cur ) / cur
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Anonymous ,
You can try dax like below:
M1 =
VAR cur =
IF (
NOT ISBLANK ( SELECTEDVALUE ( slice[tag] ) ),
SELECTEDVALUE ( slice[value] ),
BLANK ()
)
RETURN
( MAX ( 'Table'[Bananas Eaten] ) - cur ) / cur
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
44 | |
28 | |
22 | |
11 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |