Forum Discussion

ilikedata's avatar
ilikedata
New Member
5 years ago

Help Please!: Calculate Difference from Previous Date (Dates Are Missing)

Hi Everyone, Appreciate joining the community as a novice PBI user and any help that could be provided.   I have been trying to calculate the difference for rows in a table regarding cumulative dea...
Deaths
Difference Between Dates
Missing Dates
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ilikedata ,

new column =
var _max = maxx(filter(Table, [Update Date] <earlier([Update Date])),[Update Date])
return
[Total Deaths] - sumx(filter(Table, [Update Date] =_max),[Total Deaths])

 

 

a measure with date table for last available date
Last Day Non Continuous = CALCULATE(sum([Total Deaths]),filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

 

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