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

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.