Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

How to create Calendar dimension in Power BI?

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.

Anonymous
6 years ago
May be ";" instead of ","?

5 Replies

Tahreem24
Super User
6 years ago
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!
- Anonymous
  Not applicable
  6 years ago
  What could be wrong?
  - Anonymous
    Not applicable
    6 years ago
    May be ";" instead of ","?
- Tahreem24
  Super User
  6 years ago
  Hey Anonymous ,
  
  Replace ";" with "," just like below syntax.
  CALENDAR (DATE (2005, 1, 1), DATE (2015, 12, 31)
  - Tahreem24
    Super User
    6 years ago
    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!