Yet another person having Date filter issues, with full showing of work:

[TERRY_HUGHES]

I have a DAX date table, 'Date' with column [Date] set to 

Date = CALENDARAUTO(6)

Confirm that the Date column in this table is type date (not datetime) with short format:

The table is marked as a date table with Date being the date column.

Next I have imported in data from Outlook. In Power Query I have duplicated the DateTimeReceived column and then transformed the type to date:

    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Date", each [DateTimeReceived]),
    #"Extracted Date" = Table.TransformColumns(#"Added Custom1",{{"Date", DateTime.Date, type date}})

Confirm the Date is type Date and not DateTime

with same short format:

Created the relationship from Date table to the Outlook table, Date<->Date (when created I did date first then the associated table, when view Edit relationship it inverts the two):


In the report table visual, we see that 'Date'[Date] is not syncing at all with the 'Email'[Date]
First column is the original DateTimeReceived column provided by Outlook, second column is the Power Query duplicate then converted to type date, third is from my DAX date table:



The 12/30/2024 date being shown is the last day that I refreshed the data in the report.

Help me Obi-Wan Kenobi, you're my only hope!

[TERRY_HUGHES]

Update:

I disconnected the two table relationship, modified the PowerQuery code to

    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Date", each [DateTimeReceived]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom1",{{"Date", type date}})

and have also tried

    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Date", each [DateTimeReceived], type date)

refreshed, then rebuilt the Date<->Date relationship.

No change, the marked 'Date'[Date] table is not linking with the 'Email'[Date]

[v-linhuizh-msft]

Hi @TERRY_HUGHES ,

Try recreating two keys for the date table and the Email table, change the format to whole number type.

And create a relationship based on these two identical keys:

Also, notice that you are using the Date Table field in the visual, whereas you used the date field when you created the relationship, and during my testing, using the date field was the correct filtering to be done.

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.