Forum Discussion

Regular Visitor

3 years ago

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

Tips and Tricks

Ahmedx
3 years ago
1)you need to create a column index
2)

5 Replies

ribisht17
Super User
3 years ago
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
  Regular Visitor
  3 years ago
  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

Super User

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

Regular Visitor

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

Ahmedx
Super User
3 years ago
1)you need to create a column index
2)