Convert an excel formula to Power Query

[soorajskn]

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 replicated? 

[Ahmedx · Accepted solution]

1)you need to create a column index

2)

[Ahmedx]

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.

[soorajskn]

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

[ribisht17]

@soorajskn 

https://excelquick.com/excel-power-query/power-query-concatenate-text-and-numeric-data/

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[soorajskn]

@ribisht17  Thank you for your quick response. 

I am not looking for Concatenation formula.  I am trying to convert the below excel formula to power Query 

Days between  =IF($AK2=$AK3,($E3-$E2),"")

Days between = If AK2 is equals to AK3, then E3 - E2, else Null.

This is the requirement