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.
Hello Dears,
I've the below data set and I want to create a measure that calculate total number of trips with the below critera:
- Sum 'DR_DUTIES'[# Of Trips]
If
'ROSTER DATABASE'[DATE] = 'APP_TT'[Date]
&
'APP_TT'[Applied TT] = 'DR_DUTIES'[TimeTable]
&
'DR_DUTIES'[Driving Duty] = 'ROSTER DATABASE'[Activity]
Also, I need to create another measure with the same critera but to Sum 'DR_DUTIES'[Driving Hours] noting that this column is Time formatted [hh:mm:ss AM/PM].
Thanks in advance!
Please clean up /refactor your data model. Then provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
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 |
---|---|
56 | |
27 | |
23 | |
15 | |
11 |
User | Count |
---|---|
78 | |
63 | |
47 | |
17 | |
12 |