Forum Discussion
Populating data for previous month when date is missing
Hi everyone, Been scouring the forums for a solution to my issues but unfortunately haven't been able to figure it out with existing posts, so figured I'd post here and try to get some help on th...
amitchandak
Super User
Super UserRasmus_Schwerin , Make sure you have column in date table like
year Month = year([date])*100 + month([Date])
now have measure, assume already have measure M1
if(isblank([M1]), calculate(lastnonblankvalue(Date[Year Month], [M1]), filter(all(date), Date[Date] <= Max(Date[Date]) ) ) , [M1])
Thank you!
This measure works, I needed to flip the conditional statement to ">=" for it to work, otherwise it was doing the opposite of what I was intending.
Really appreciate the assistance, thank you
/Rasmus