Forum Discussion
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...
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
Yes i did create the date table without any relationship to the fact.
Created the same model as u did.
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