Forum Discussion
Colin970
Oct 28, 2022Copper Contributor
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 ...
- 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
Oct 28, 2022Copper Contributor
Riny_van_Eekelen
Oct 28, 2022Platinum Contributor
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.
- Colin970Oct 28, 2022Copper ContributorHi
Thats great do i add this to my sheet- Riny_van_EekelenOct 28, 2022Platinum Contributor
Colin970 Are you asking how you should add this to my sheet?
I assume you are somewhat familiar with PQ. Then you should be able to follow the applied steps in my file and create similar ones in your own file. Perhaps you can just copy most of them over directly. I can't tell without seeing your file.
- Colin970Oct 28, 2022Copper ContributorGreat I will try that ,I do have a limited knowledge of PQ hope it works thanks again
Colin