Month to Month Variance- Nepal Date

[aashish]

Is there any way to calculate month to month variance using nepali (Nepal) Date i.e BS date.?

[ValtteriN]

Hi,

I recommend adding a Nepal Date calendar table to you model and then using that in your visuals. For month over month calculations you can the use standard methods involving functions like DATEADD or PARALLELPERIOD. For example on how to create the calendar table needed refer to this post by Greg_Deckler: Dalai Lama Kung Fu Calendar (Bikram Sambat) - Microsoft Fabric Community

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/