Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |