Forum Discussion

mhsk's avatar
mhsk
Helper II
4 years ago

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...
Need Help
mhsk's avatar
mhsk
Helper II
4 years ago

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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

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]
  )