Userelationship and prior period

Anonymous · ‎02-15-2022

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 · ‎02-15-2022

@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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎02-15-2022

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 · ‎02-15-2022

@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?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎02-15-2022

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