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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bmunagapati
Frequent Visitor

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

@bmunagapati 

 

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
bmunagapati
Frequent Visitor

Thanks for your solution, it works.

WinterMist
Impactful Individual
Impactful Individual

@bmunagapati 

 

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.