Forum Discussion

MHTANK's avatar
MHTANK
Helper III
1 year ago
Solved

Previous Day Value

Date VALUE 01-11-2024         126 02-11-2024         494 08-11-2024         78 08-11-2024         88 25-11-2024         98 30-11-2024         108 02-12-2024         11...
Need Help
ThxAlot's avatar
ThxAlot
Super User
1 year ago
PREV_LASTNONBLANK = 
VAR __prev =
    CALCULATE( LASTNONBLANK( DATA[Date], 0 ), DATA[Date] < MAX( DATA[Date] ) )
RETURN
    CALCULATE( [SUM Value], DATA[Date] = __prev )
PREV_OFFSET = 
CALCULATE( [SUM Value], OFFSET( -1, ALLSELECTED( DATA[Date] ) ) )

MHTANK's avatar
MHTANK
Helper III
1 year ago

Yes, this is work 👍🏻 in this data.

But in my original data (company's data) this is not work for the starting day of month. Can you please tell me what problems may be happening?