Forum Discussion

BItoken's avatar
BItoken
Helper III
5 years ago
Solved

Compare data between 2 dates

Hi All,   I have a History tracking table that tracks all changes for a given account and loads all changes with a load date to the table. Now in Power BI we need to create a comparison of data be...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi BItoken ,

     

    Since you have many other filters on the table visual, so all(table) will have some issue. Please use the following measure for instead:

     

    Measure new = IF(MAX(renewals_history[eff_start_dt]) = CALCULATE(MAX('renewals_history'[eff_start_dt]),FILTER(ALL(renewals_history[eff_start_dt]),'renewals_history'[eff_start_dt]<=MAX('Date'[Date]))),1,0)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi BItoken ,

 

Please confirm that you create a new date table for slicer and  it has no relationship with the fact table.

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

BItoken's avatar
BItoken
Helper III
5 years ago

Yes i did create the date table without any relationship to the fact.

Created the same model as u did.

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi BItoken ,

     

    Did you use the date column from the new table as date slicer? It's better that you can show me your pbix file for troubleshooting. It's quite difficult for me to tell you where you did wrong without your pbix file since it works well in my test pbix.

     

    Best Regards,

    Dedmon Dai