Forum Discussion
Show Measure for missing data point in dax
mhsk So, what you will need to do is to check if the value returns blank and you will need a table VAR that returns values for each date. Then you can get the MAX (MAXX) Date where that value is not blank and use the value for that date. I don't really know the specifics of your source data so it's hard to be specific.
Greg_Deckler yes this is the logic i would need to pass to get the result. Check if blank its easy with ISBLANK but i can overcome creating virtual table that will check what is the last non blank value/date and copy that to any blank field until new value is present in the fact table. Would you suggest any solution? .pbix file is here https://we.tl/t-fgPJcyZ3ci
Greg_Deckler any chance you could have a look at the pbix?
what you have written: "you will need a table VAR that returns values for each date." doesnt show up in any scenario which approach shall i take? any suggestion appreciatedmhsk So, the concept would be this:
New Measure = VAR __Table = SUMMARIZE('Table',[Date],"__Value",[Your measure]) RETURN IF(ISBLANK([Your measure]), VAR __Date = MAXX(FILTER(__Table,[__Value] <> BLANK(),[Date]) RETURN MAXX(FILTER(__Table,[Date] = __Date),[__Value]), [Your measure] )