Forum Discussion
Solved
Incorrect DISTINCTCOUNT value when counting unique dates in table
I've got a table showing a list of orderlines with SKUs, ordernumber, etc. I'm trying to eventually get to a measure showing the average number of orders per day, however my number of day calculation...
Hi nickappftna ,
Create a column datevalue(datecolumn)
Then do a distinct count on that column, it should work.
Did I help you today? Please accept my solution and hit the Kudos button.
Interesting. This does work -- thank you for the quick answer. Though I'm not sure I understand why my original (failed) solution does not work. Isn't the point of adding ".[DATE]" to specify that I only want to look at the date portion of the TimeStamp? ...as opposed to .[Day], .[Month], etc.?
davehus
Memorable Member
Memorable MemberIt's actually not something I've used before and oddly enough there isn't much documentation on it on the MT website. I'll have to go digging into the dax guide to see.
If this has worked for you, please accept it as a solution 🙂 Thank you.