Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Previous value in DAX

Hello,   I would like to use two sets of values for one timestamp, i.e. [Date]. Thus, all values before today, including today, have to be equal to value3. All values after today have to be equal ...
DAX
previous value
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

try like:

VAR PrevValue =
MAXX(
   FILTER(
      TableName,
      TableName[Date]=EARLIER(TableName[Date])-1
    ),
   TableName[Value]
)