topic Not able to get the previous day stock quantity into the curent day if the current day has no stock. in DAX Commands and Tips

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

Dave21 — Wed, 23 Aug 2023 14:17:05 GMT

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.

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

Anonymous — Mon, 28 Aug 2023 06:57:05 GMT

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