Forum Discussion
Date table connection to another table
I want to connect my date table with the TrackET but If I connect with the dates like delivery on in TrackET it shows nothing.
The dates in TrackET are from the Typ date and date/time is this the problem?
Here is my data. I want connect my date table with the dates for example PO Date from table trackit
- You need to convert the Date Time to date so it will connect to your date table date. I would do this in Power Query if possible (there's even a button for it in the Add column tab), but you could use DAX functions as well.
1 Reply
- AllisonKennedy
Community Champion
You need to convert the Date Time to date so it will connect to your date table date. I would do this in Power Query if possible (there's even a button for it in the Add column tab), but you could use DAX functions as well.