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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ldamato
Frequent Visitor

How to calculate difference from 2 dynamic columns in Matrix

Hi, 

 

I have a matrix where I choose the columns using the slicer. This slicer contains all dates available on my data source.

ldamato_0-1658165864302.png

My goal here is to create a third column where I can calculate the diference of the "coverage" measure. 

Another problem is that I use unpivoted columns, so if I add anoter field to the "value" area, it will insert one more column for each column. 

 

Any help with this? 

 

Thanks,

Leo

 

4 REPLIES 4
lbendlin
Super User
Super User

Sounds like you are using Field Parameters?

 

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hi @lbendlin , thanks for your reply.

 

The outcome is in the picture below. My wish was to have 2 slicers with single selection (one for the first date and one for the latter), and then check the coverage for both, then the variation: 

The dates available in the slicer would come from the column "datadate" from the sample data. 

ldamato_0-1658252386176.png

Here is the sample data: https://1drv.ms/u/s!Ase08ylVBg_VmVrA2O-wyaVcEWHs?e=MERVOh 

(coverage formula for each column of the sample data is: (1 - (count of N/A in column / count of all column))
coverage variation formula is (last date - first date)

 

Thank you for the help!

Hi, @ldamato 

 

The data you provided in the link doesn't quite match the data in your chart. Do you need another conversion?

vzhangti_0-1658393440714.png

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin_0-1658272307428.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.