Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm trying to write a measure that would allow me to count all the rows in a column that contain "11:00:00 AM" or any time before that. Table name is Master and column name is Order Time.
Thank you in advance!
Solved! Go to Solution.
Another method:
CALCULATE (
COUNT ( Orders[Order Time] ),
Orders[Order Time] <= TIME ( 11, 0, 0 )
)
Thank you, worked like a charm!
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
39 | |
20 | |
12 |