Forum Discussion
help dax
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
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-5c3243d1f9
1 Reply
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-5c3243d1f9