Sum of each year up to the current month

[PBI_newuser]

Hi, I have the below line and stacked column chart. The FY2023 sum is up to last month which is Feb'2023 but FY2021 and FY2022 is full year. How to show the sum for each year up to Feb only? E.g FY2021 up to Feb'2021, FY2022 up to Feb'2022 and FY2023 up to Feb'2023. 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Ahmedx]

And you can  create fiscal year and month

[PBI_newuser]

Hi @Ahmedx , after created Fiscal month, how to make the VAR _NumberLastMonth to be same as Fiscal month but not Calendar month?

Measure =

VAR _NumberLastMonth = MONTH( EOMONTH(TODAY(),-1))
VAR _Result = CALCULATE([sales],'Calendar'[monthnumber]<=_NumberLastMonth)

RETURN
_Result

[Ahmedx]

Measure =
VAR _NumberLastMonth = 
CALCULATE(MAX('Calendar'[Fiscal month]),'Calendar'[Date]= EOMONTH(TODAY(),-1))

VAR _Result = CALCULATE([sales],'Calendar'[Fiscal month]<=_NumberLastMonth)
RETURN
_Result

[Ahmedx]

I'm not sure, but you can try writing the measure like this

[Ahmedx]

Measure =
VAR _NumberLastMonth = CALCULATE(MAX('Calendar'[Fiscal month]),'Calendar'[Date]= EOMONTH(TODAY(),-1))

VAR _Result = CALCULATE([sales],'Calendar'[Fiscal month]<=_NumberLastMonth)
RETURN
_Result

[PBI_newuser]

Hi @Ahmedx , the financial year starts from october and ends in september. How to adjust the monthnumber for this ?

[Ahmedx]

you can give your file to see how we can help. I especially need to see your calendar table