Counta for last month with inactive relationship

[jh292]

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! 

[Jihwan_Kim · Accepted 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.