Forum Discussion
Strange behaviour Date Hierarchy
Hi jjimenez ,
You can refer to the similar case, as v-shex-msft said, when you turn on time intelligence option, power bi will try to analysis your data value column as a hidden calendar. These extend fields which you mentioned are from analyzed hidden calendar, you can directly use these fields to get different date unit from date value without specific dax date functions.(year, month, day...)
It can help power bi to analysis data and summarize records with different date level and provide support with dax time intelligence functions(such as YTD, MTD, PREVIOUSYEAR...), It can help you calculate records with specific date filters more simply.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi jjimenez ,
You can refer to the similar case, as v-shex-msft said, when you turn on time intelligence option, power bi will try to analysis your data value column as a hidden calendar. These extend fields which you mentioned are from analyzed hidden calendar, you can directly use these fields to get different date unit from date value without specific dax date functions.(year, month, day...)
It can help power bi to analysis data and summarize records with different date level and provide support with dax time intelligence functions(such as YTD, MTD, PREVIOUSYEAR...), It can help you calculate records with specific date filters more simply.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.