How to create Calendar dimension in Power BI?

[Anonymous]

I need to slice data by year, month, week, day. How to create calendar table easily in Power BI? My primary data source is CosmosDB thus I don't have SQL DB available. 

[Tahreem24]

HI @Anonymous ,

Create Calculated Table as "Calendar" and enter expression like below:

CALENDAR (DATE (2005, 1, 1), DATE (2015, 12, 31)

You can refer below links for more reference:

1. https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

2. https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/ 

Please dont forget to give Thumps up and accept this as a solution!

[Tahreem24]

Hey @Anonymous ,

Replace ";" with "," just like below syntax.

CALENDAR (DATE (2005, 1, 1), DATE (2015, 12, 31)

[Tahreem24]

@Anonymous ,

I will really appreciate your KUDOS.

And my suggestion helped you so please mark it as a solution so other can take help from it!

Thanks!

[Anonymous]

What could be wrong?

[Anonymous · Accepted solution]

May be ";" instead of ","?