Forum Discussion

Colin970's avatar
Colin970
Copper Contributor
Oct 28, 2022
Solved

Power Query Add Step

Hi,   I am unable to work out in power query how to add a step to calculate Column "Time-Copy.1" to have a column produce the "Required Result.   Hope somebody can help   Regards   Colin   ...
power bi
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Oct 28, 2022

    Colin970 See attached. Created the query in PQ for the Mac. It has a slightly different set-up. That's why the initial steps look a bit different. Didn't bother to re-write the M-code.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 28, 2022

Colin970 At a first glance it seems that you want the time stamp to show Top-2 if the row below it has Top-2 in it. But that logic fails for the 4:42 PM at the bottom as it should have 0, not Top-2.  So please clarify.

 

Colin970's avatar
Colin970
Copper Contributor
Oct 29, 2022
Hi

I have tried and tried even to the point of gettind a headache I an struggling to reproduce step 4 "Expand Added Index1"
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 29, 2022

    Colin970 Can you share a sample file via OneDrive or similar? Just remove anything confidential, as long as the  structure/layout remains the same as your real file.

    • Colin970's avatar
      Colin970
      Copper Contributor
      Oct 29, 2022
      Hi

      See link thers is no sensative information. Excuse my attemps to consoliate, if its too hard or you do not have time I understand. Thanks again

      https://1drv.ms/u/s!AuL2hHx5FRiPib1SSjtT7GQiVgGyNg?e=Ubt3Tz
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Oct 29, 2022

        Colin970 And now please explain what you've sent and where I should begin looking. 🙂

Resources