Forum Discussion
mhsk
Helper II
4 years agoShow 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...
mhsk
Helper II
4 years agoThanks for promp reply Greg_Deckler , you just realized me my measure is not returning any value as there is no value for given calendar table week so nothing to return, now i made it work with simple allexept but i see my problem is more complex:
I found now that i need to reference to previus calculated measure value, not to constant value when there is no value to show from fact table, would you advise how to build such measure (that will produce the same value that was present in previously (previous date) ?
so what i'm receiving now is this:
and i'm expecting this:
many thanks for all your suggestions - not only in this topic, they save lives! (and a lot of time)