Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a table with several times
GOAL: I need to create a start and end filter by time, filtering this table
What I've done so far:
I created a table that separates the time of a day from 15 to 15 minutes. 00:00 to 23:45
I want to select the start time and end time, and then it will filter the table within that range. In the example above it would be from 01:00 to 01:15
So the result should be:
I created a filter creating a condition, but I feel like I'm still far away:
Can anyone help me?
Solved! Go to Solution.
@jonathangsanto , Create two independent table with these time slots and the try a measure like
new measure =
var _max = maxx(allselected(Time2),Time2[Time])
var _min = minx(allselected(Time1),Time1[Time])
return
calculate( Count(Table[Time]), filter('Table', 'Table'[Time] >=_min && 'Table'[Time] <=_max))
worked perfectly! Thank you very much
@jonathangsanto , Create two independent table with these time slots and the try a measure like
new measure =
var _max = maxx(allselected(Time2),Time2[Time])
var _min = minx(allselected(Time1),Time1[Time])
return
calculate( Count(Table[Time]), filter('Table', 'Table'[Time] >=_min && 'Table'[Time] <=_max))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |