Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
It seems my date table is not working the correct way.
I have created a simple new tabel with = Calendarauto().
Added the month and selected mark as datetable.
Now I dont see the calendar icon near date.
Also when i create a filter with months its not in the right order.
In ideas how this could have happend? I have checked the formats
Solved! Go to Solution.
Hi, @Mike89
You can try a different way of creating a new date table.
Table:
Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Mike89
You can try a different way of creating a new date table.
Table:
Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks you the seems to work.
HI @Mike89 ,
Try right-clicking on your date table --> "Mark as date table"
Select and validate the date column
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |