help dax

[superME79]

Hello
I would need a hand to understand if any of you have ever faced a similar problem.
I have 3 tables consisting of: date ;id ; attribute I'm relating them together to get a table with data distinct count ID for attibute. Unfortunately some dates are not the same so when I bring the measurements in a single view I have holes. Is it possible to create a measure that replaces missing data with a difference between the values ​​from the previous date? let me know thanks a lot

[amitchandak · Accepted solution]

@superME79 , assume you have two meausres

This Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))

Then you can have measure

if(isblank(This Day], [Last Day], [this day])

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...