Forum Discussion
BGB
Helper II
Helper IIUSEREALTIONSHIP convert to date in VAR
Hi all, I have a calendar table date column that I'm trying to connect to my main table with an arrival date column. However, the arrival date is in datetime format. The question is: How do ...
BGBHelper II
Helper IIThe question is to convert the date-time column to date only using Dax while using the USEREALTIONSHIP function.
This is not very tricky. You have a date-time column that needs to connect to your calendar date column. Because the calendar date does not have time we need to convert our date-time column to date only but without doing that in Power Query , can it be done using DAX?
Hi BGB ,
As Ashish_Mathur said, this shouldn't be possible with dax, it's recommended to get the data types converted first.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- BGB
Your recommendation is not useful here. Thanks for your time.