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.
I have a historical crash dataset which has records for date and time.
Date | Time |
19/05/2019 | 8:43:00 AM |
30/11/2019 | 7:45:00 PM |
19/07/2019 | 6:30:00 AM |
I'm trying to use Q&A to ask for records during a certain time of day. It's not bringing up any results, and on investigation, it's because it's defaulting to "today"
eg
The most recent data is from 2019 so there is no reason for it to default to today. How can I stop it from defaulting to today, and actually looking for the time in the Time variable?
Solved! Go to Solution.
Hi @rachellek
create a measure
hour = HOUR(SUM('Table'[Time]))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rachellek
create a measure
hour = HOUR(SUM('Table'[Time]))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Q&A needs the date dimension. You could add a suggested question where you ask "latest number of crashes... by date"
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |