Forum Discussion

user900's avatar
user900
Icon for Helper II rankHelper 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
Icon for Community Champion rankCommunity 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
Icon for Helper II rankHelper 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.