Forum Discussion
Post PartisanNeed help with a date measure please
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
Super UserRichOB , Could you please elaborate on your request in more detail?
Post PartisanHi Kedar_Pande sure,
Between the dates of 03/06/2024 and 01/09/2024 there have been 5 total instances being reported, 2 of which do not have an end date as the cell is blank. I'd like a measure that will show the count of instances where the Date Completed cell is empty specifically between the date range above. So in this circumstance, 2 out of the 5 have not been completed yet. I can then use that measure to show on a card the number 2 and also use it in other calculations. I hope that helps.
Thanks
- Kedar_Pande
RichOBHow will you determine the date range? Is it set, or would you like to include a slicer to choose the start and end dates for calculating the blank instances between those dates?
- RichOB
- RichOB
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