Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello Power Bi super solvers,
Could you help me get over the hill by converting a number into hours?
Background: My data has a field - 30-minute session. The row has 0, 1, 2, 3, etc. Each number represents a 30-minute session. For example, 4 means four sessions at 30 minutes each. Therefore, it should equal two hours.
Could you nudge me in the right direction to show the output as E.G. 11:30, 24:00, etc.?
Any resource is greatly appreciated.
Thank you
Luis
Sample Tables
Student Name | Student ID | Tutor | Sessions Week | 30-minute Sessions | Sessions Weeks (Groups) |
Luna Jeremiah | 82272 | Binder, Judy | 2-1 Sessions | 11 | First Six Weeks |
Luna Jeremiah | 82272 | Binder, Judy | 3-1 Sessions | 8 | Second Six Weeks |
Luna Jeremiah | 82272 | Binder, Judy | 3-3 Sessions | 2 | Third Six Weeks |
Monarrez, Kamila | 46278 | Binder, Judy | 1-4 | 12 | First Six Weeks |
Monarrez, Kamila | 46278 | Binder, Judy | 2-4 | 12 | Second Six Weeks |
Monarrez, Kamila | 46278 | Binder, Judy | 3-4 | 4 | Third Six Weeks |
Envisioned Output
Student Name | Student ID | First Six Weeks | Second Six Weeks | Third Six Weeks | Total Hours (HH: MM) |
Monarrez, Kamila | 46278 | 06:00 | 06:00 | 02:00 | 14:00 |
Luna Jeremiah | 82272 | 05:30 | 04:00 | 01:00 | 10:30 |
Could someone point me in the correct direction?
Thank you.
Solved! Go to Solution.
What happend if you have more than 24h (48 sessions x 30 min)?
You can also change to data type time with the column.
Proud to be a Super User!
Try this. It is great that you want to understand the synthax! 🙂
Proud to be a Super User!
Apologies for the delayed response.
@andhiii079845 - Thank you.
It worked exactly as expected.
Appreciate your willingness to share your expertise.
What happend if you have more than 24h (48 sessions x 30 min)?
You can also change to data type time with the column.
Proud to be a Super User!
forgot to add that i am stuck on this DAX
I see now that you forget something after RETURN. There has to be s calculations or a return of a variable
Proud to be a Super User!
Hi @andhiii079845 - i think i see what you mean.
Could you give me another friendly nudge in correcting the syntax? I believe I want variables HourNo and MinuteNo to be returned in the DAX.
Thank you for everything.
Sorry for my late answer.
Proud to be a Super User!
Hi @andhiii079845,
No worries about the timing of the response. I appreciate your follow-up.
I am still learning the syntax, but your response indicates that this syntax is incorrect - per the error message. I have played around with the syntax but can't get it correct.
This visual almost does what I want.
The tooltip is great
I want the Y axis to show the number of tutoring hours in HH:MM.
Any gentle nudge on my syntax is greatly appreciated. I still can't upload a PBIX. Wish that I could, would make my message and intent clearer.
Try this. It is great that you want to understand the synthax! 🙂
Proud to be a Super User!
That works! Thank you very much.
I know it is limiting to troubleshoot with a PBIX file. Hopefully, I can upload a PBIX file next time I post a problem.
Can you share please all involved column for your dax expression?
Proud to be a Super User!
User | Count |
---|---|
11 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
25 | |
19 | |
16 | |
10 | |
7 |