Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
Just wondering if someone can help me with a measure....
I'm trying to count the number of customerID's with a "DateEntered" in last month. This I can do however I need to use an inactive relationship and I can't work out how to fit in the 'userelationship' into the formula....
Many thanks if you can help!
Solved! Go to Solution.
Hi, @jh292
Try something like below.
Measures =
CALCULATE (
[your measure name],
USERELATIONSHIP ( datetable[datecolumn], facttable[inactivedatecolumn] )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @jh292
Try something like below.
Measures =
CALCULATE (
[your measure name],
USERELATIONSHIP ( datetable[datecolumn], facttable[inactivedatecolumn] )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.