Forum Discussion
Show Measure for missing data point in dax
Hi, I have a fact table with data but not for all data points in calendar table, when i trow data into matrix it shows blanks when there is no corresponding value - which is ok, but i'm trying to...
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 appreciated
mhsk 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] )
