How to add Calender(with sub catagories) in power BI

[Reddyp]

Add new column into Power BI and add below DAX code

Calender = Addcolumns(CALENDARAUTO(),

"YEAR", YEAR([Date]),

"MonthNo", MONTH([Date]),

"Month", FORMAT ([Date],"mmm"),

"Quarter", FORMAT ([Date],"\QQ"),

"YearMonth", FORMAT ([Date],"YYYY-MM"),

"WeekdayNo", WEEKDAY([Date],2), //1-Sun..Sat, 2-Mon..Sat

"Weekday", FORMAT ([Date], "ddd"))

 
Output:

[Anonymous]

HI @Reddyp,

Thanks for your share.  It seems like you share the calculated table expression, it was not suitable to be used in the calculated column.

For this scenario, I think it should be used with a calculated table to generate the calendar with custom fields.

Regards,

Xiaoxin Sheng

[VahidDM]

Hi @Reddyp 

Please see this link:

https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/