Unknown Field Icon

[imnotarobot]

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.

[V-lianl-msft]

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.

[mhossain]

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.

[imnotarobot]

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

[harshnathani]

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)