Forum Discussion
Jdokken
Helper III
Helper IIIIncorrect data for selected Previous and current periods
Hello- I've created a measure that will bring back data in the most current period and previous period (when two dates are selected). Ex: JAN-2021 and NOV-2020. If there isn't project data in one of ...
JdokkenHelper III
Helper IIII created this formula and it worked, except now it's bringing back the Sum of each project Name when rolled up to the Operating Group Level.
CY Sales Board PQ =
Var CurrDate = CALCULATE(MAX('Board & IFD'[Date]),
FILTER(ALLSELECTED('Board & IFD'),'Board & IFD'[Date]))
VAR PrevDate = CALCULATE(MAX('Board & IFD'[Date]),
FILTER(ALLSELECTED('Board & IFD'),'Board & IFD'[Date] < CurrDate),
VALUES('Board & IFD'[Project Name] ))
VAR PrevAmount = CALCULATE(
[CY Sales Board],
FILTER(ALLSELECTED('Board & IFD'), 'Board & IFD'[Date] = PrevDate),
Values('Board & IFD'[Project Name]))
RETURN
PrevAmount