Forum Discussion

Post Prodigy

6 years ago

Solved

Calendar Table Only Showing One Date

Hi All,

I created a calendar table but it only shows one date? What am I doing wrong?

Thanks

az38
6 years ago
Hi HenryJS
I think its a wrong date format question
try
Table = CALENDAR( DATE(2001,1,1), DATE(2021,1,1) )

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

The same as below.

Table 2 =
CALENDAR (
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2001 ), DATETIME ),
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2021 ), DATETIME )
)

4 Replies

az38
Community Champion
6 years ago
Hi HenryJS
I think its a wrong date format question
try
Table = CALENDAR( DATE(2001,1,1), DATE(2021,1,1) )

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
zoloturu
Memorable Member
6 years ago
Hi HenryJS ,

Just use double quotes:

Table = CALENDAR("01/01/2001","01/01/2021")

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups
amitchandak
Super User
6 years ago

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Community Support

The same as below.

Table 2 =
CALENDAR (
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2001 ), DATETIME ),
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2021 ), DATETIME )
)