Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone
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 date and time format.
The question is: How can I convert the arrival date to use userelationship in my measure without creating a new date-only column?
Solved! Go to Solution.
Hi, @Syndicate_Admin
Thanks for the reply from @PhilipTreacy .
I create a sample table:
First, create an inactive relationship between the two tables.
Then create a DAX measure, and use the USEREALTIONSHIP function to specify the inactive relationship.
ShipDate_RM3 = CALCULATE(
SUM('Table'[Quantity]),
USERELATIONSHIP('Date'[Date], 'Table'[Arrival Date]),
FILTER('Table', 'Table'[Source] = "RM3")
)
Here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Syndicate_Admin
Thanks for the reply from @PhilipTreacy .
I create a sample table:
First, create an inactive relationship between the two tables.
Then create a DAX measure, and use the USEREALTIONSHIP function to specify the inactive relationship.
ShipDate_RM3 = CALCULATE(
SUM('Table'[Quantity]),
USERELATIONSHIP('Date'[Date], 'Table'[Arrival Date]),
FILTER('Table', 'Table'[Source] = "RM3")
)
Here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What exactly are you trying to do?
You don't need to create a new date column from the date/time to use it in measures. You could just use functions like YEAR, MONTH and DAY with DATE to create a date.
The answer depends on what it is you want to do.
Phil
Proud to be a Super User!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |