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 try something like this:

 

One Measure = 
VAR __CurrentDate = TODAY () 
VAR __SelectedDate =  MAX ( 'File Date'[File Date] ) 
VAR __DatesTable = { __SelectedDate, __CurrentDate }
RETURN
    CALCULATE ( 
        SUM('Table_data'[Value]),
        KEEPFILTERS (
            TREATAS ( __DatesTable, 'Date'[Date] )
        )
    )