Forum Discussion
Visualize Data During Last 1 Year (Example: 01 June 2021 until 31 May 2022)
I have monthly data that will be updated every first day of the month. I have a case, to visualize data during 1 last year, for example when slicer year = 2022 and month = 5, it will take data from ...
Rupak_bi
Super User
Super UserHope you are looking for below result. Your formula is correct. only you need to use selected value. Else you may use below formula.
new value =
calculate(SUM(Test[value]),
all(DIM_DATE),
DIM_DATE[Date]>=date(SELECTEDVALUE(DIM_DATE[Date].[Year])-1,SELECTEDVALUE(DIM_DATE[Date].[MonthNo])+1,1),
DIM_DATE[Date]<=max(DIM_DATE[Date]))
Thank you for the solution, but what missing is, from your solution you are using 1 slicer, right now I using 2 different slicer Year and Month, so what if the case right that?
Hope you can also help me for this case...