Forum Discussion
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. My goal here is to create a third column where I can calculate...
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!
