How many Months Left till End of FY

[sunil222]

Hi Team,

I want to calculate how many months left till end of FY.

eg: current month is december , fiscal year staring from April so i need the value 3 because fy end on March 24.

please help me on the dax calculation to get the value

[marcoperson_250]

Thank you for sharing this type of question 

[Fowmy · Accepted solution]

@sunil222 

Create the following meaure:

Month Count = 
VAR __Mon =   MONTH(MAX( 'Dates'[Date] ) )
RETURN
    IF( __Mon > 3 , 15 - __Mon , 3 - __Mon)

[sunil222]

I need the answer as 3 , now december value is 3 ,  i can use this value in another dax calculation.

as per your logic iam getting

[Fowmy]

@sunil222 

You need to create a measure with the code thatI shared with you