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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Calculate difference between two variable columns in a matrix

Hi Community,

 

I am rather new to the community. I have a question regarding variable columns. I have created a Matrix which shows columns based on the selection in a slicer using a separate table with the following formula:
image.png


Now I would like to calculate the difference between the first and the second column. Are there any solutions on how to get there?

Thank you for your help.

2 REPLIES 2
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

Sorry I can’t replicate your issue, could you please share us your detailed data and expected data ? It’s preferred to share us your detailed data (upload your pbix to Onedrive and share links here) but kindly masking your confidential info.

 

We’d like to provide further support once we got it.

 

Best regards,

Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Hi Dina,

 

thank you very much for your reply.

I was able to sort out the problem.
Thank you very much anyhow.

 

Best

lenn93

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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