Chinese Lunar Calendar

Question

Hello everybody&nbsp;&nbsp;😀&nbsp;I need to be able to manage the lunar calendar as well as the fiscal calendar and the gregorian (standard) calendar, this because i need to compare chinese marketing activities from one year to another and they are based on the lunar calendar (- chinese new year month1-day1,- lantern festival month1-day15,- dragon boat festival month5-day5,- double 7 also called the valentine's day month7-day7)&nbsp;here my questions :&nbsp;1. What is the best structure to adopt in my time dimension to be able to manage these 3 dates knowing that my fact tables contains a date in gregorian calandar ? could you please give me a pbix ?&nbsp;2. what is the best way create the slicer and give to the user the possibility to chose a period of time (ex: to create 2 fields to input the date and 3 check box (Fiscal, Standard, Lunar) ??? ), could you please add it in the pbix ?&nbsp;Thanks a lot for your help&nbsp;&nbsp;Philippe&nbsp;&nbsp;&nbsp;

amitchandak · Answer

We typically create a single calendar and try to accommodate the calculations there.&nbsp;
You can create custom months, year and create their sort and incremental Ranks.
&nbsp;
Refer:https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
&nbsp;

philippecn · Answer

HEllo&nbsp;amitchandak&nbsp;&nbsp;&nbsp;Thank you for you answer, I understand the logic&nbsp;concernnig the question #2 , how do you male coexist in a slicer all the calendars making that the user can chose if he wants the standard, fiscal or lunar ? is their a check box thing to chose or a parameter somewhere ?

greg_deckler · Answer

One method is to create a disconnected table with your choices of calendars. Then, you can have a measure select the appropriate date column from your calendar. Not sure of what your use cases are so hard to say exactly. You could also do this with bookmarks and buttons and that might work better if you have circumstances where dates are on the axis of a visual for example.

amitchandak · Answer

This one is a bit tricky. Changing the calendar is easy. But change all calculation based on that would be a bit tricky
&nbsp;
Like how you change measure using slicer. But you will have too many to change based on that
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
&nbsp;
Or bookmarks to hide the complexity
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

philippecn · Answer

Thank you, I will try these options and tell you if it works

Forum Discussion

Chinese Lunar Calendar

6 Replies

Related content

Calendar Slicer with Different Business Calendars

Custom calendar

Tweaking Financial Calendar

Lunar Missions

Weeknum as per Calendar