topic End of month calculation for custom calendar in DAX Commands and Tips

End of month calculation for custom calendar

Jagdish_Jha — Thu, 18 May 2023 04:24:38 GMT

Hi Gurus,

I am currently working on a report where I have local Nepali calendar that has month start from about mid of english month and year end in about mid of April. How can I calculate End of Month for this type of calendar. I have a data that has end of month balance based on Nepali month end date. I have limited time to close this project.
Your help will be greately appriciated.

Regards,
Jag

Re: End of month calculation for custom calendar

FreemanZ — Sat, 20 May 2023 11:09:45 GMT

hi Jagdish_Jha

you have already a good date table linking the two calendars. What challenge do you face specifically?

Re: End of month calculation for custom calendar

ppm1 — Sat, 20 May 2023 12:34:03 GMT

I would add a Nepali year column and then create a DAX column that gets the MAX date for the same year and month. For example,

NepaliEOM = CALCULATE ( MAX ( Date[NepaliDate] ), ALLEXCEPT ( Date, Date[NepaliYear], Date[NepaliMonth] ) )

Pat