Solved: Counta for last month with inactive relationship

jh292 · ‎04-09-2021

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 · ‎04-09-2021

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.

Click here to visit my LinkedIn page

View solution in original post

Jihwan_Kim · ‎04-09-2021

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.

Click here to visit my LinkedIn page