Forum Discussion

JoaoMS's avatar
JoaoMS
Icon for Helper III rankHelper III
3 years ago
Solved

Create colum with the difference of two rows

Hi all,   I've been trying to figure out how to create a new column in Power Query in order to calculate the difference between two values of some columns. Every day we get data of Accumulated Oper...
Need Help
Tips and Tricks
JoaoMS's avatar
JoaoMS
Icon for Helper III rankHelper III
3 years ago

Hi Ashish_Mathur , so you mean that it is more complicated to create these new columns in Power Query, because what we currently do is manually calculate these data in the source excel file, and then in Power Query we treat the data (unpivot and pivot) in order to get the following table and then easily create some visualizations:

DateMotorDaily HourAcc. Hours
28/04/2023Motor 1                    -             15,400
28/04/2023Motor 2                    -               8,752
29/04/2023Motor 1                   24           15,424
29/04/2023Motor 2                   12             8,764
30/04/2023Motor 1                     4           15,428
30/04/2023Motor 2                   21             8,785

Thanks,

Joao

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

I would not suggest writing those custom column formulas in the Query Editor.  After unpivoting the raw dataset, we can write DAX measures to calculate the hours of each day.  If you need further help, then share the data with information of 10 motors (columns).