Forum Discussion
Solved
Calculation Group Variables — MAXX Calendar Date Less Specific Number of Days
Hello All, Within a calculation group, I'm attempting to set up two PriorDay variables that work with selectedmeasure()... The first would be the maxx calendar date less 1 day, and the other maxx...
1Kash_PBI , I case some dates are selected and you want fo beyond those dates, use all
VAR MeasurePriorDay = CALCULATE(Selectedmeasure(),FILTER(all('Calendar'),'Calendar'[Date] = vPriorDay))
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
1Kash_PBI , I case some dates are selected and you want fo beyond those dates, use all
VAR MeasurePriorDay = CALCULATE(Selectedmeasure(),FILTER(all('Calendar'),'Calendar'[Date] = vPriorDay))
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9