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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

powermoss is this what you want assuming Sep 21st is selected?

 

 

  • powermoss's avatar
    powermoss
    Regular Visitor
    2 years ago

    parry2k yes that looks like what I'm after. Assume the user selects 21-Sept, a value of the measure would appear in two columns - one for 21-Sept and one for yesterday (24-Sept). 
    I think what you've done above is take off the Switch values to rows option on the matrix?  I was hoping to have that on, as I will be putting a long list of measures (approx. 20) into the visual, and if I take that option off the user has to scroll a long way left and right to see each measure's value.  Hopefully the picture I put in the .pbix was there, but just in case, this is the desired result: