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...
Need Help
lbendlin's avatar
lbendlin
Super 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!

    • v-zhangti's avatar
      v-zhangti
      Community Support
      4 years ago

      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.