Forum Discussion

Frequent Visitor

4 years ago

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...

Need Help

ldamato

Frequent Visitor

4 years ago

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!