Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jagdish_Jha
New Member

End of month calculation for custom calendar

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.

 

Jagdish_Jha_0-1684383977939.png


Regards,
Jag

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

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

Microsoft Employee
FreemanZ
Super User
Super User

hi @Jagdish_Jha 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.