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...
Rasmus_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