Not able to get the previous day stock quantity into the curent day if the current day has no stock.

[Dave21]

Hello All, I am struggling to get the previous day stock quantity into the current day where it has no stock. Basically its a comparison between actual and previous day stock quantity. Will get to know better by screenshots.

For eg: For example 25th june should show the stock as 16,17,17,669.00 as 22,23,24 june had no stock. Can anyone please help/suggest me a dax code for this , i have been trying to make a new measure for this problem.

[Anonymous · Accepted solution]

HI @Dave21,

You can extract the current date and use it as condition to find out the previous records with stock not equal to blank, then you can and use this result to show on the blank parts.

formula =
VAR currDate =
    MAX ( Table1[Pay day] )
VAR prevDate =
    CALCULATE (
        MAX ( Table1[Pay day] ),
        FILTER ( ALLSELECTED ( Table1 ), [Stock] > 0 )
    )
RETURN
    CALCULATE (
        SUM ( Table1[Stock] ),
        FILTER ( ALLSELECTED ( Table1 ), [Pay day] = prevDate )
    )

Regards,

Xiaoxin Sheng