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-11-23 10:39 |
| order4 | 2020-11-24 14:29 |
| order5 | 2020-11-24 14:37 |
In slicer it shows all dates with different time but I want to show only dates so when I select that date all orders would be listed in table. In this example instead of showing all dates in slicer I want to show only two dates:
2020-11-23
2020-11-24If I select 2020-11-23 in slicer , then show order1,order2, and order3 in report.
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
1 Reply
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