topic Re: How many Months Left till End of FY in DAX Commands and Tips

How many Months Left till End of FY

sunil222 — Sun, 24 Dec 2023 11:30:29 GMT

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

Fowmy — Sun, 24 Dec 2023 12:43:11 GMT

sunil222

Create the following meaure:

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

sunil222 — Mon, 25 Dec 2023 08:34:44 GMT

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 — Mon, 25 Dec 2023 09:58:12 GMT

sunil222

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

marcoperson_250 — Mon, 25 Dec 2023 15:36:05 GMT

Thank you for sharing this type of question