Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Userelationship and prior period

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
Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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?