Forum Discussion

user900's avatar
user900
Helper II
2 years ago
Solved

Help with Date

I have a data file that includes a Report Month field (10/1/2022 through 10/1/2023).  Data type is set as Date.  I want to create a measure to get the distinct count of IDs on or before 7/1/2023.  Bu...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi user900 
    Please try below measure

    Total Count= CALCULATE(COUNT('Table'[ID]),FILTER('Table','Table'[Date]<=DATE(2023,07,01)))

    If my post helps please give kudos and accept it as a solution!
    Thanks
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi user900 
Please try below measure

Total Count= CALCULATE(COUNT('Table'[ID]),FILTER('Table','Table'[Date]<=DATE(2023,07,01)))

If my post helps please give kudos and accept it as a solution!
Thanks
  • user900's avatar
    user900
    Helper II
    2 years ago

    Fantasic!  I did make a minor change.

    Total Count= CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table','Table'[Date]<=DATE(2023,07,01)))

     

    Thank you so much.