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.

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

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        You are welcome.  The DATESBETWEEN() function used in the YTD terminations measure ensures that the arithmatic (distinctcount in our case) starts from the 1st day of the year and goes till the last date of the month chosen in the visual filter.

    • mikeborg82's avatar
      mikeborg82
      Advocate II
      8 years ago

      i see you had to apply filters to the page.  is that the only way to handle this?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Using filters is the easiest way to make it work.