Userelationship and prior period

[Anonymous]

Hi,

I thought that I was writing a simple formula but I get a "Blank" result.  I am trying to get a count of the deals that were created in the same period of the prior year.  I need to use the USERELATIONSHIP function because my dates table has a primary link to a different date column in the data set.  The current month count works perfectly (I used the same formula without the DATEADD filter.  What am I missing?

LY Created # = CALCULATE(COUNT('Pipe Drive'[Value]),

DATEADD('Dates Table'[Date], -1, YEAR),

USERELATIONSHIP('Dates Table'[Date], 'Pipe Drive'[Deal created]))

Thanks,

John

[parry2k]

@Anonymous I know what is the reason, check this video on my youtube channel which explains why it is happening and what is the solution https://youtu.be/AWOmTMdpCNw

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Anonymous]

I watched your video but I don't see how it applies.  My normal date slicers work well.  My only issue is my prior period dax measures when I am using USERELATIONSHIP.  Maybe I am missing something?

[parry2k]

@Anonymous How you are viewing this new measure? If you add a table visual, put months or year from date tables and this measure, do you get the value?

[Anonymous]

At this point I just want to see the count on a card.  The card ends up showing "Blank".