Forum Discussion

ldamato's avatar
ldamato
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 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

 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      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!