Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Experts, Need your help on the below secnario.
1. I have one measure and dates always fetches only two dates ex: June 2023 & Dec 2022. If I put my measure in matrix visual and keep the dates column in Matix columns and it gets splitted i.e. fine. However, Now Business user is asking to see the difference from current vs. previous only instead of Dec 2022. Below is snapshot current vs. expectation from business user.
Current:
Expectation:
Solved! Go to Solution.
@Anonymous
The following should deliver the result you are looking for.
NOTE: I have left some of the "middle steps" measures in the table visual below only for readability. But they can be removed to match what you have shown in your desired results screenshot.
First, build the base measures that will be used in the other calculations:
Second, build the measures that calculate each metric for the PP (Previous Period):
Finally, build the measures that get the difference between the current values & the PP (Previous Period) values:
Hope this is helpful to you.
Regards,
Nathan
Thanks for your solution, it works.
@Anonymous
The following should deliver the result you are looking for.
NOTE: I have left some of the "middle steps" measures in the table visual below only for readability. But they can be removed to match what you have shown in your desired results screenshot.
First, build the base measures that will be used in the other calculations:
Second, build the measures that calculate each metric for the PP (Previous Period):
Finally, build the measures that get the difference between the current values & the PP (Previous Period) values:
Hope this is helpful to you.
Regards,
Nathan
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
13 | |
12 | |
9 |