Forum Discussion
Unknown Field Icon
I have a file with these two items Quarter and Week. They're in a date table but I can't find out where it is created since it is not on the source query.
4 Replies
Hi imnotarobot
You have a date column, and hierarchy is created for month/quarter/week based on that date column. So physically you just have 1 date column, and in visuals you can drage these hierarchy created columns.
If you want to create physical month/quarter/week in your table, then there are multiple ways, you can use create custom/calculated columns for these.
Hope this makes sense.
It makes sense but I created a new table with one date field and set that to a date table but these fields are not added automatically and I don't know how to add them manually
Hi imnotarobot ,
This is due to Auto Date Time which the DAX engine uses.
To disable this follow this article.
https://www.youtube.com/watch?v=xu3uDEHtCrg
https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/
https://www.youtube.com/watch?v=mAZR5Hf0NYQ
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi imnotarobot ,
This is Analytics Clustering.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
