Forum Discussion

james_james_jam's avatar
james_james_jam
New Member
8 years ago

convert excel formula to power query

hello,   i wish to convert a excel formula into power query format.   i import a CSV file into data model and do calculation within that data model, thats why i cannot use excel formula.   i am...
Michal_cwiok's avatar
Michal_cwiok
Icon for Resolver II rankResolver II
8 years ago

james_james_jam, would it be possible if you posted an example table before and after the formula? It will be easier for us to be on the same page with you.

 

Thanks

james_james_jam's avatar
james_james_jam
New Member
8 years ago

 

 

 

Thanks Michal,

im not able to upload whole excel, so i print screen instead. this is the working example i created in excel form, now i scratching my head to convert this into power query form, at least i know it is doable in excel, so i hope i can translate it into power query

 

the column H is the new column i wish to create. as you can see, serialNO is unique, but some does re-appear in later row. 

  • Michal_cwiok's avatar
    Michal_cwiok
    Icon for Resolver II rankResolver II
    8 years ago

    First occurence means first occurence by date?

    • james_james_jam's avatar
      james_james_jam
      New Member
      8 years ago

      Dear Michal,

       

      yes, it is by date, however i know the nature of the data, it has to be sequencial according to time, so we can assume the entry of the data is following real time nature, such that newer data is at last entry