Forum Discussion

powermoss's avatar
powermoss
Regular Visitor
2 years ago
Solved

Compare measure value over two dates

I am trying to create a table or matrix which compares measure values on two dates - yesterday to a user-selected second date.   In Excel this is a lookup column to a tale containing yesterday's da...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    powermoss here is the previous file with the updated measure and it is working, since it doesn't have today's data it is not showing that date but if you put today's data it will work - today's vs selected date

powermoss's avatar
powermoss
Regular Visitor
2 years ago

parry2k you're awesome for helping on this.

 

That new one seems to have scuppered things somewhat.  I've updated the dataset and published it again here.

 

I'm stumped on how to get just two columns of data to show: the date chosen from a slicer, and Today's date. I've tried a few FILTER arguments myself, and wasn't aware of the TREATAS function, but I can't seem to limit my results to only two columns when there is a date range between TODAY and the selected value.