cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

when to use Date.[date] ?

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

 

pbi date.png

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @ilcaa72,

 

When you turn on time intelligence option, power bi will try to analysis your data value column as a hidden calendar.

17.PNG

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @ilcaa72,

 

When you turn on time intelligence option, power bi will try to analysis your data value column as a hidden calendar.

17.PNG

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors