End of month calculation for custom calendar

[Jagdish_Jha]

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

[ppm1]

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

[FreemanZ]

hi @Jagdish_Jha 

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