Forum Discussion
JoaoMS
Helper III
Helper IIICreate 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...
Hi,
You may download my PBI file.
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
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).
JoaoMSHelper III
Helper III- Ashish_Mathur
Hi,
You may download my PBI file.
Hope this helps.