Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

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:

bmunagapati_1-1689173224383.png

Expectation:

bmunagapati_0-1689173015677.png

 

1 ACCEPTED SOLUTION
WinterMist
Impactful Individual
Impactful Individual

@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.

 

WinterMist_0-1689196158416.png

 

First, build the base measures that will be used in the other calculations:

 

WinterMist_1-1689196211917.png

WinterMist_2-1689196235023.png

WinterMist_3-1689196250659.png

 

WinterMist_4-1689196292098.png

 

Second, build the measures that calculate each metric for the PP (Previous Period):

 

WinterMist_5-1689196474682.png

 

WinterMist_6-1689196504072.png

 

WinterMist_7-1689196524003.png

 

Finally, build the measures that get the difference between the current values & the PP (Previous Period) values:

 

WinterMist_8-1689196593020.png

WinterMist_9-1689196607147.png

WinterMist_10-1689196629291.png

 

Hope this is helpful to you.

 

Regards,
Nathan

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks for your solution, it works.

WinterMist
Impactful Individual
Impactful Individual

@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.

 

WinterMist_0-1689196158416.png

 

First, build the base measures that will be used in the other calculations:

 

WinterMist_1-1689196211917.png

WinterMist_2-1689196235023.png

WinterMist_3-1689196250659.png

 

WinterMist_4-1689196292098.png

 

Second, build the measures that calculate each metric for the PP (Previous Period):

 

WinterMist_5-1689196474682.png

 

WinterMist_6-1689196504072.png

 

WinterMist_7-1689196524003.png

 

Finally, build the measures that get the difference between the current values & the PP (Previous Period) values:

 

WinterMist_8-1689196593020.png

WinterMist_9-1689196607147.png

WinterMist_10-1689196629291.png

 

Hope this is helpful to you.

 

Regards,
Nathan

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors