Forum Discussion

NickPowerBI's avatar
NickPowerBI
Regular Visitor
6 years ago

Latest Budget Version based on date filtering

We are looking for the latest budget based on a budget version and date filtering.  Consider the following dataset:   Budget Table (related to a date dimension)   Project Name Subtask Budge...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

NickPowerBI , Try column like after join date with date of date table

Only repeat till year

YTD = CALCULATE(MAX(Table[Budget]),DATESYTD('Date'[Date],"12/31"))

 

repeat till end
Cumm = CALCULATE(MAX(Table[Budget]),filter(date,date[date] <=maxx(date,date[date])))

 

Or

 

YTD = CALCULATE(lastnonblankvalue(Table[Date], MAX(Table[Budget]),DATESYTD('Date'[Date],"12/31"))


repeat till end
Cumm = CALCULATE(lastnonblankvalue(Table[Date], MAX(Table[Budget]),filter(date,date[date] <=maxx(date,date[date])))