Column Label in Formula Question

DAX DAX Calculations
1

Hello,

sometimes I some sate columns used in formula where the name is followed by a .DATE. example I have

Sales Header [Pick Ticket Date].[Date]

What does that . [DATE} do, also why does it only appear in some of my date columns?

thanks
Jeff

1 Like
2

The .[Date] is the automatic date functionality/date tables that Power BI has in the background.

I recommend you turn this feature off and use your own date table when attempting any time intelligence functions. I’ve included a link to a SQLBI article underneath the picture, they explain it far better than I can.

image
image658Ă—629 31 KB

Automatic time intelligence in Power BI - SQLBI

3

I agree completely with @DavieJoe’s suggestion. The Auto Date table bloats your report unnecessarily, which many new users don’t realize.

The setting shown in the post above is the global setting (which is my preference), but this can also be found in the Data Load options for Current File (which is found near the bottom of the left-hand pane of the Options menu).

Also very import - when using your own date table, you need to mark it as a date table (right-click on the table, and look for there to be a check-mark in this area “Mark as date table” setting.
image

1 Like
4

Thanks @Heather - excellent points, thanks for following up.

DJ

1 Like
5

Thanks everyone

1 Like