Forum Discussion
Power BI Desktop - Calculate datediff with information from same column
datanau001
You can Pivot the Status Column on the Change Date Time field then add a new field to calculate the difference.
Select the Status Column, under Transform Tab, click Pivot Column,
Under the Value column, Select Change-Date-Time column, Select No Aggregation under Advanced Option.
now you get two columns ACCEPTED and QUEUED. select those columns, under Add Columns Tab, select Time and Subtract.
You will get a new column with the time difference.
If you find any difficulties, post a sample data with your reply to demonstrate.________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
datanau001
You can Pivot the Status Column on the Change Date Time field then add a new field to calculate the difference.
Select the Status Column, under Transform Tab, click Pivot Column,
Under the Value column, Select Change-Date-Time column, Select No Aggregation under Advanced Option.
now you get two columns ACCEPTED and QUEUED. select those columns, under Add Columns Tab, select Time and Subtract.
You will get a new column with the time difference.
If you find any difficulties, post a sample data with your reply to demonstrate.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
