Forum Discussion
Calculate difference of dates in rows
I have a table that consists of many job numbers, activity name, and dates. Every job is listed twice because we are only looking at two activity names: Final Closing Walkthrough & Foundation -...
you want to do in PowerQuery, look at Pivot and make Job 1-110-110 one row with ActivityName values used as a new column like (Final Closing Walkthru and Foundation - Concrete as column names as well as Base End Date and Act End Date. Then you can do a DateDiff between the date columns
Pivot job creates every job as a new column. Pivoting other columns makes the values 1 or 0. I might be misinterpreting your response