Forum Discussion

nickappftna's avatar
nickappftna
New Member
4 years ago
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...
Need Help
  • davehus's avatar
    davehus
    4 years ago

    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.

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

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.

nickappftna's avatar
nickappftna
New Member
4 years ago

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's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    It'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.