Forum Discussion
Anonymous
6 years agoNot applicable
Inception to Date financials
Hi, I have certain measures stored in the database table that are all inception to date financials at the quarter end. To represent these financials properly, I need to pick the amounts from the ...
- 6 years ago
amitchandak
Super User
6 years agoAnonymous You can have something like this with a Date calendar
Measure =
var _max = maxx(allselected(Date[qtr-year]),Date[qtr-year])
var _maxDt = maxx(filter(Date,Date[qtr-year]=_max),Date[Date])
var _maxM = maxx(filter(Date,Date[Date]=_maxDt),Date[Month-year])
return
calculate(sum(Table[revenue]),filter(all(Date), Date[Month-year]=_maxM))
But difficult say without a sample data and sample output.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/