Forum Discussion
Distinct Job Count based on Start Date
Hi, I need to get a distinct count of jobs based on Entered Date. This is the day that it was entered into our systems. For some reason, the data that shows is only working based on Start Date fo...
HI Matt_Mohawk
Please try the following
Number of jobs =
VAR __MinDate = MIN(DimDate[Date])
RETURN
CALCULATE(
DISTINCTCOUNT(FactTable[JobNumberColumn]),
DimDate[Date] >= __MinDate
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Thank you for responding so quickly. I am still getting the same number. I have pasted an image below of the formula I created. Is it set up correctly?
