Forum Discussion

JLambs20's avatar
JLambs20
Helper III
3 years ago
Solved

Count Unique Values in a Date Range

Hello!   I am trying to write a measure that will count the unique values in a column (the value can show up many times in the column in question).  Each row also has a start and end date but my vi...
Need Help
  • Padycosmos's avatar
    Padycosmos
    3 years ago

    Hope this helps.

     

     

     

JLambs20's avatar
JLambs20
Helper III
3 years ago

Padycosmos 


Hello again!

 

First off, thank you again for the solution to the previous issue.  It's working perfectly.  However, I need to expand on this just a bit and I'm having some trouble with the DAX.  

Looking at the dataset you listed above, I now need to count the number of items that have Pre-Treatment start date within the date range that is selected (the date in the slicer on my page is the date column from my calendar table).  For example, if I were to select the entire month of January as my date range, I'd see a count of 1 because it's the only project with a start date in January and is listed as "Pre-Treatment".  Can this be worked into the current DAX statment or would we need a new one for the calculation? 
Thank you in advance.