ruthhacche
Board Regular
- Joined
- Sep 22, 2017
- Messages
- 84
I have a parameter to select my current Fiscal Year,
Profit Selected FY = calculate([Profit], filter( 'Calendar','Calendar'[FiscalYear]='Parameter This FY'[Parameter This FY Value]) ) works
Profit Selected Last FY = calculate([Profit], filter( 'Calendar','Calendar'[FiscalYear]='Parameter This FY'[Parameter This FY Value]-1) ) works
cumulative works for this year
Profit Cumulative FY Selected = CALCULATE(
[Profit Selected FY],
filter(
aLL('Calendar'[Date]),
'Calendar'[Date]<= MAX('Calendar'[Date])
)
)
But I cannot do that for the previous year - This does not work. How do I get this one to look back 12 months?
Profit Cumulative Previous FY Selected = CALCULATE(
[Profit Selected Last FY],
filter(
aLL('Calendar'[Date]),
'Calendar'[Date]<= MAX('Calendar'[Date])
)
)
Profit Selected FY = calculate([Profit], filter( 'Calendar','Calendar'[FiscalYear]='Parameter This FY'[Parameter This FY Value]) ) works
Profit Selected Last FY = calculate([Profit], filter( 'Calendar','Calendar'[FiscalYear]='Parameter This FY'[Parameter This FY Value]-1) ) works
cumulative works for this year
Profit Cumulative FY Selected = CALCULATE(
[Profit Selected FY],
filter(
aLL('Calendar'[Date]),
'Calendar'[Date]<= MAX('Calendar'[Date])
)
)
But I cannot do that for the previous year - This does not work. How do I get this one to look back 12 months?
Profit Cumulative Previous FY Selected = CALCULATE(
[Profit Selected Last FY],
filter(
aLL('Calendar'[Date]),
'Calendar'[Date]<= MAX('Calendar'[Date])
)
)