Creating auto current and prior fiscal year calculation

Question

I'm struggling&nbsp; to find a solution to creating a calculation that finds the max fiscal year and prior fiscal year, then applies those to a calcultion. I'm a little new to Power BI and would appreciat e any help you could offer.&nbsp;I have this measure that works fine:Current Fiscal Year Actual = CALCULATE(sum('Gross Revenue by Service Area - FLAT'[Actual]), 'Gross Revenue by Service Area - FLAT'[Fiscal Year - FiscalYear]=2019)&nbsp;I was hoping there's a way to replace the "2019" in the above measure with some that would automatically update each year. &nbsp;I created this measure:CFY VALUE = max('Gross Revenue by Service Area - FLAT'[Fiscal Year - FiscalYear])&nbsp;Is there a way to convert this measure [CFY VALUE] to a values so that I may insert it into my calculation statement and not have to type in "2019"&nbsp;Thanks for any help you can offer as i learn!Terry&nbsp;

tbobolz · Accepted Answer

I found this tread that solves this issue, thanks to all you have looked!

https://community.powerbi.com/t5/Desktop/Set-a-filter-based-on-MAX/td-p/20175

I also extrapolated on this to create a MTD value as well, for comparing YOY MTD finding.

Thanks

Terry

Forum Discussion

Creating auto current and prior fiscal year calculation

1 Reply

Related content

Need help to create Calculation in DAX

Create calculated row

Creating ICMs via Activator

Semantic model - create calculated column

MoM calculation