Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Previous Date value based on the date selection

Hi Everyone,   I'm trying to get the Previous Date's value for each Team. Below is the way I have relations in my model.  And in the dashboard, Date slicer is there (Dates Master Table). So, based ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Use independent date table as slicer and create a measure like below:

    Measure = 
var _previous = EDATE(MAX('Date'[date]),-1)
return
CALCULATE(SUM(TransactionTable[value]),FILTER(TransactionTable,TransactionTable[Date]=_previous))

    Or create a measure as below and add it to visual filter set value = 1:

    Measure 2 = 
var _previous = EDATE(MAX('Date'[date]),-1)
return
IF(SELECTEDVALUE('TransactionTable'[Date])=_previous,1,0)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Use independent date table as slicer and create a measure like below:

Measure = 
var _previous = EDATE(MAX('Date'[date]),-1)
return
CALCULATE(SUM(TransactionTable[value]),FILTER(TransactionTable,TransactionTable[Date]=_previous))

Or create a measure as below and add it to visual filter set value = 1:

Measure 2 = 
var _previous = EDATE(MAX('Date'[date]),-1)
return
IF(SELECTEDVALUE('TransactionTable'[Date])=_previous,1,0)

 

Best Regards,

Jay

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

There @Syndicate_Admin ,

Thank you! I just removed all relations and recreated. Now its working.