Forum Discussion

mikeborg82's avatar
mikeborg82
Icon for Advocate II rankAdvocate 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
Icon for Advocate II rankAdvocate II
8 years ago

I also tried using this pattern, but to not luck:

PY YTD Terms = CALCULATE(DISTINCTCOUNT(Terms[Employee Number]),(SAMEPERIODLASTYEAR(DATESYTD('Date Dim'[Date]))))