Forum Discussion
Solved
Convert an excel formula to Power Query
I have an excel formula which I am trying to replicated on power query AK – Concat (text) E – Opened (Date) Days between =IF($AK2=$AK3,($E3-$E2),"") Can someone explain me how this can be...
1)you need to create a column index
2)
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.
Hello Ahmedx
Thank you for your response. Here is the excel sheet.
Opened Concat-User/CI/Subcat Days BWN 13-03-2023 10:52 A00011Active Directory PasswordHow To 14-03-2023 15:38 BB00532Active Directory PasswordHow To 0.083333333 14-03-2023 17:38 BB00532Active Directory PasswordHow To 22-03-2023 13:03 AA00800WN-KSSlow/Freezing 1.166666667 23-03-2023 17:03 AA00800WN-KSSlow/Freezing
