Forum Discussion
Sum values current date - sum values last date
Using date calendar date you can do like
CALCULATE(SUM(Base[MCL Current value SEK]);Dateadd('Date'[Date],-1,DAY))
Or example
last date having data
Measure =
var _max = maxx(allselected(Date),Date[DAte]) // or take Today()
//OR var _max = maxx(allselected(Sale),Sales[DAte]) // or take Today()
var _max2 = MAxx(filter(sales,sales[Date]<_max),sales[Date])
return
calculate(sum(sales[value]),Date[Date] =_max2)
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/