cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors