Forum Discussion

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...

Ashish_Mathur
8 years ago
Hi,

You may see my solution here.

Hope this helps.

Advocate II

8 years ago

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

Super User

8 years ago

Hi,

You may see my solution here.

Hope this helps.

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
  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
    Advocate II
    8 years ago
    Yes, this makes perfect sense. I assumed when I used a function like "TotaLYTD", that powerbi would know to give me the total of the year I am in YTD at the time, and I wouldn't need to add a filter. My date dimension table goes for several years ahead, so this could be why when I use the totalytd function with no filter, I get blank results.
    
    Thanks again for your help.
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
  Super User
  8 years ago
  Hi,
  
  Using filters is the easiest way to make it work.

Related content