Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table with datetime field, I want to add a new measure to show totals per date in a visual and from this I also want a disctinct count on the dates in the table. Help appreciated.
@jamiefisher , A date column without time, and then you can use that
Date = datevalues([Datetime])
measures
m1= distinctcount(Table[Datetime])
m2= distinctcount(Table[Date])
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |