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.

mikeborg82's avatar
mikeborg82
Advocate II
8 years ago

sorry to keep this going - but now I run into the following error message when trying to pull in other fields into the visual.

 

but when i refer to the date table, i do not get the right values.  but that causes other issues like this since not referring to date table.  i must be doing something wrong, but can't seem to figure it out.