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 column that I created through a mesuare that add two columns but it is in minutes instead of hours which I need for comparision reasons. I found several different ways to do this on the forum but was confused on how to actually impliment it.
Here is what I am wanting to do. The column in bold is what I am hoping to accomplish.
v_rpt_service Table
ART_Resolved_Actual | ART_Resolved_Actual_Hour |
0 | 0 |
300 | 5 |
112 | 1.86 |
256 | 4.26 |
854 | 14.23 |
42 | 0.71 |
Thanks!
Solved! Go to Solution.
Divide ART_Resolved_Actual by 60.
ART_Resolved_Actual_Hour=ART_Resolved_Actual/60.
Am i missing something here , looks so simple 🙂
Thanks
Raj
Divide ART_Resolved_Actual by 60.
ART_Resolved_Actual_Hour=ART_Resolved_Actual/60.
Am i missing something here , looks so simple 🙂
Thanks
Raj
What I ended up having to do was dividing both columns by 60 that were used to create the calculated column (ART_Resolved_Actual) and then re-add them which worked.
Unfortunatly It doesn't appear to be that simple. I also ran the forumla you posted with the same result.
How ART_Resolved_Actual is being calculated ?
Thanks
Raj
ART_Resolved_Actual = CALCULATE(SUM(v_rpt_Service[Minutes_Waiting])+SUM(v_rpt_Service[Resolved_Minutes]))
Thanks!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |