Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Need help with a date measure please

Hi, if I want to get a count of the days with no Date Completed date between 03/06/2024 and 01/09/2024, what would that look like? I want a card to show the number 2 please. Customer Number ...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    RichOB ,

    Please refer the below DAX and output:

     

    Your Kudos/Likes are much appreciated! 
    If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
    Regards,
    Kedar Pande
    www.linkedin.com/in/kedar-pande

     

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
1 year ago

suparnababu8 Just for more context, I have a measure that gives me the total of 5 between that date range, I just need to add something to this to only bring back the total of the Date Completed where the cell is blank:

Reported = (
    CALCULATE(
        Count('Sheet1'[Customer Number]),
        'Sheet1'[Date Reported]>=DATE(2024,6,3),
        'Sheet1'[Date Reported]<=Date(2024,9,1)
    ))

Thanks
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Does this measure work?

Reported = CALCULATE(Count('Sheet1'[Customer Number]),'Sheet1'[Date Reported]>=DATE(2024,6,3),'Sheet1'[Date Reported]<=Date(2024,9,1),'Sheet1'[Date Reported]=blank())