Forum Discussion
How to add hours differences from same column
Hi! I'm wondering how I can extract hours differences between PM_OPENED_AT between the one Preventative Maintenance and following each NON-Preventative Maintenence. I appreciate your he...
Do you have a column that relates the rows to the same transaction? You need some start and end data relationship. Once you have that, you can use something like:
This will give you a difference between two fields in Powery Query. Can you provide more context?
Tim
I know, but the thing is when I differentiate to date columns in Preventative and Non-Preventative, it does gives like this. So I can't get differences between these two columns since if there is value in NON_PM Date, there is empty value in same row in PM_OPENS column.