Forum Discussion

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
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.
colin970.xlsx19 KB

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

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
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
  Platinum Contributor
  Oct 29, 2022
  Colin970 And now please explain what you've sent and where I should begin looking. 🙂
  - Colin970
    Copper Contributor
    Oct 29, 2022
    Riny_van_Eekelen Hi yes I was not sure what to send you so I zipped all information. If you look at the spread sheet TAB 'TOP 2' that's where you will find the Query that I have been trying to update.. Hope this helps Regards Colin