Forum Discussion
Need help measures in Matrix Visual
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:
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
2 Replies
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