Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i am trying to understand when to use the extra parameters when using the date functions. they appear as .[date], .[month], etc
if my simple calculation, if i use this parameter, it either only shows zeros, or doesnt work at all, so i am trying to figure out when these should be used and hopefully explain why... if I dont use these extra parameters, my calculation works fine..
any insight? thanks
Solved! Go to Solution.
Hi @ilcaa72,
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 analysed hidden calendar, you can direct use these fields to get different date unit from date value without specific dax date functions.(year, month, day...)
It can help power bi 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 and summy records with specific date filters more simply.
>>if my simple calculation, if i use this parameter, it either only shows zeros, or doesnt work at all, so i am trying to figure out when these should be used and hopefully explain why...
Notice, these extend date fields still not fully works with dax functions, some functions still need to use original column name to find out related values to calculate.
Reference links:
Time Intelligence in Power BI Desktop
Regards,
Xiaoxin Sheng
Hi @ilcaa72,
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 analysed hidden calendar, you can direct use these fields to get different date unit from date value without specific dax date functions.(year, month, day...)
It can help power bi 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 and summy records with specific date filters more simply.
>>if my simple calculation, if i use this parameter, it either only shows zeros, or doesnt work at all, so i am trying to figure out when these should be used and hopefully explain why...
Notice, these extend date fields still not fully works with dax functions, some functions still need to use original column name to find out related values to calculate.
Reference links:
Time Intelligence in Power BI Desktop
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |