Forum Discussion
Distinct value
I've an order table in which some of orders has been created in different time but on the same day: Ordernr Orderdate order1 2020-11-23 10:20 order2 2020-11-23 10:27 order3 2020-1...
Anonymous , Create a date column without timestamp and use that.
Date = [Orderdate].date
or
Date = date(year([Orderdate]),month([Orderdate]),day([Orderdate]))You can also use distinctcount(Table[Date])
or
distinctcount(Table[Ordernr]) measures in visual
Anonymous , Create a date column without timestamp and use that.
Date = [Orderdate].date
or
Date = date(year([Orderdate]),month([Orderdate]),day([Orderdate]))
You can also use distinctcount(Table[Date])
or
distinctcount(Table[Ordernr]) measures in visual