Hi guys!
My data has annualized revenue for every fiscal period. When I create a chart with fiscal year in slicers and this annualized revenue as values, it sums all the annualized revenue from the 12 periods which won't make sense as the annualized value in every fiscal period is already kinda like a year value. Is there any smart way to combat this?
I was thinking of some DAX function that if for exampel we select 2022, 2023, 2024 it will selected the annaulized value of the last period. But then comes the issue of selecting the proper fiscal period for 2024 as the "last" one will be either empty (if it will select period 12) or it will select period that is still "open", so not fully filled with values.
Any tips how to deal with it?
