Forum Discussion

soorajskn's avatar
soorajskn
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...
Need Help
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    1)you need to create a column index

    2)

  • soorajskn's avatar
    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