Forum Discussion
Casi
Helper I
Helper IWork out dates between one column on multi rows
Hi, I have a table 'audit' containing all the different stages of an appeal. I need to work out the dates between the date the status was changed but I am struggling without a start date. ...
In the attached, the same query adapted to a changed column name from Date Notified to createdon.
It produces just short of 900k rows so I've reduced it to one row (to be able to attach it here) which means you'll need to refresh the query to see those rows. it takes a few seconds to generate those rows…
CasiHelper I
Helper ISorry i still need assistance
p45cal
Solution Supplier
Solution SupplierSeems every obstacle under the sun is being presented to us:
Meanwile I'm looking at SundarRaj 's Excel file's Power Query query.
Meanwhile, one question. are you grouping by ceox_auditlogid or ceox_incidentid or something else?
- Casi
Sorry just picked this upim grouping by incident id