Forum Discussion
Running Percentage based pn Two columns ( DAX)
I have a table like this below
| Table 1 | |||
| S.No. | Equipments | Vessels | Sum of Duration in Hrs |
| 1 | Equipment 1 | Vessel 1 | 30:15:00 |
| 2 | Equipment 2 | Vessel 1 | 19:15:00 |
| 3 | Equipment 3 | Vessel 1 | 3:56:00 |
| 4 | Equipment 4 | Vessel 1 | 0:25:00 |
| 5 | Equipment 1 | Vessel 2 | 40:56:00 |
| 6 | Equipment 2 | Vessel 2 | 20:10:00 |
| 7 | Equipment 3 | Vessel 2 | 7:43:00 |
| 8 | Equipment 4 | Vessel 2 | 2:10:00 |
| 9 | Equipment 5 | Vessel 2 | 0:10:00 |
I want to add one another column in that which shows me Running Percentage of Sum of Duration in Hrs Based on Each Vessels.
Same equipment will be present in other vessel to ,, But the Running Percent should be reset based on Vessel. I know how to do with one column value. But I dont know how I can do using two column.
Below is the sample Table which is required.
| Table 1 | ||||
| S.No. | Equipments | Vessels | Sum of Duration in Hrs | Sum of Duration in Percentage |
| 1 | Equipment 1 | Vessel 1 | 30:15:00 | 80 |
| 2 | Equipment 2 | Vessel 1 | 19:15:00 | 92 |
| 3 | Equipment 3 | Vessel 1 | 3:56:00 | 100 |
| 4 | Equipment 4 | Vessel 1 | 0:25:00 | 100 |
| 5 | Equipment 1 | Vessel 2 | 40:56:00 | 83 |
| 6 | Equipment 2 | Vessel 2 | 20:10:00 | 88 |
| 7 | Equipment 3 | Vessel 2 | 7:43:00 | 95 |
| 8 | Equipment 4 | Vessel 2 | 2:10:00 | 100 |
| 9 | Equipment 5 | Vessel 2 | 0:10:00 | 100 |
Basically I am trying to create a pareto curve, Is there is any way to do using DAX formula.
Hi Amir851
Please check if this post could help you.If it is not your case,please explain more about your expected output.Please let us know how to get Sum of Duration in Percentage?You may give some formulas of values 80 and 92 about how to get them.By the way,what's the data type of Sum of Duration in Hrs?
Regards,
Cherie
1 Reply
Hi Amir851
Please check if this post could help you.If it is not your case,please explain more about your expected output.Please let us know how to get Sum of Duration in Percentage?You may give some formulas of values 80 and 92 about how to get them.By the way,what's the data type of Sum of Duration in Hrs?
Regards,
Cherie