topic Need help measures in Matrix Visual in DAX Commands and Tips

Need help measures in Matrix Visual

Anonymous — Wed, 12 Jul 2023 14:51:25 GMT

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:

Re: Need help measures in Matrix Visual

WinterMist — Wed, 12 Jul 2023 21:19:44 GMT

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

Re: Need help measures in Matrix Visual

Anonymous — Tue, 25 Jul 2023 12:03:44 GMT

Thanks for your solution, it works.