How to calculate difference from 2 dynamic columns in Matrix

[ldamato]

Hi, 

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

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

[lbendlin]

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

[ldamato]

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. 

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!

[v-zhangti]

Hi, @ldamato 

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

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]