Forum Discussion

mikeborg82's avatar
mikeborg82
Advocate II
8 years ago
Solved

DAX help

PY YTD Terms = CALCULATE(DISTINCTCOUNT(Terms[Employee Number]),FILTER(SAMEPERIODLASTYEAR('Date Dim'[Date]),CONTAINS(VALUES('Date Dim'[Prior Year]), 'Date Dim'[Prior Year], 'Date Dim'[Date])))   I h...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may see my solution here.

     

    Hope this helps.

mikeborg82's avatar
mikeborg82
Advocate II
8 years ago

PY Test = CALCULATE(DISTINCTCOUNT(Terms[Employee Number]),SAMEPERIODLASTYEAR(Terms[Actual Termination Date]))

 

It seems to work like this... when i refer to the date dimension table it doesnt seem to work, but this way it does.  Does that seem right?  could there be a reason that this is happening and maybe something i should fix upstream?  Thanks, still getting my feet wet with DAX and powerbi.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You have to create a relationship from the Actual Termination data column of the Terms Table with the Date column of the calendar table.  If you need more specific help, share the link from where i can download your file.

  • mikeborg82's avatar
    mikeborg82
    Advocate II
    8 years ago

    Thanks. sent you message with the link.  it is just a sample test file.  thanks again for any help!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      You may see my solution here.

       

      Hope this helps.

      • mikeborg82's avatar
        mikeborg82
        Advocate II
        8 years ago

        thank you.  this does work!  do you think you could explain what the issue was so i will know for future models?  THanks again i really appreciate the help