Forum Discussion
Date icon is different
Anonymous , Once mark a table as Date Table, The Date you chose become id column. This sign for that. This is not more behave like a date. You will also not get a date hierarchy for that.
You can create a new column as per requirement and create a hierarchy on that or have another date column
Refer this link for more definition
Identity field: Fields with this icon are unique fields, set to show all values, even if they have duplicates. For example, your data might have records for two different people named 'Robin Smith', and each will be treated as unique. They won't be summed.To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. 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/
Super UserAnonymous , Once mark a table as Date Table, The Date you chose become id column. This sign for that. This is not more behave like a date. You will also not get a date hierarchy for that.
You can create a new column as per requirement and create a hierarchy on that or have another date column
Refer this link for more definition
Identity field: Fields with this icon are unique fields, set to show all values, even if they have duplicates. For example, your data might have records for two different people named 'Robin Smith', and each will be treated as unique. They won't be summed.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. 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/
Thanks amitchandak . It's really helpful.
Hello Amitchandak,
I have a date table that is experiencing this problem as described in this thread.
I created a duplicate column of the date column, called it dateH. Date had become a primary key column. I expected dateh column to be a heirarchy date, but it does not load into the data table that way.
What am I doing wrong?
- Jim