Power Query - Unstack Rows with List.Alternate
There are many ways to Unstack rows into columns in this tutorial i show you how to use list.Alternate and then a little bonus how to do it in one line using list.Split.
#dataanalytics #excel #powerbi #powerquery #powerbidesktop #tutorial #mquery #microsoft
File Link
github.com/jbotes/powerbiTuto...
MQuery Links
List.Alternate
learn.microsoft.com/en-us/pow...
List.Skip
learn.microsoft.com/en-us/pow...
List.split
learn.microsoft.com/en-us/pow...
table.FromColumns
learn.microsoft.com/en-us/pow...
Пікірлер: 19
Impressive stuff. I have to accept that it will take me years of practice to master Power Query and DAX.
Amazing! Thanks a lot!
Fantastic
brilliant!
Interesting! But to get an array from a list the fast way is to use the index function with sequence.
Great series of videos and learnt a lot of PQ functions!
Thanks!!!
Good stuff, James. Always learning new things with you.
Awesome..! Never knew about list.alternate
Complex function. Thank you.
Awesome as always 👍
Dankie!!!
@basensei8699
3 ай бұрын
plesier Chris!
Hey James, it sounds like your microphone audio is mixed only through the left channel. Your audio effects are correctly playing through both the left & right channels. As a quick band-aid, you could try turning your microphone audio from dual channel to mono! I do see that you're using a dedicated microphone, so it's possible your not recording from the correct source. Hard to diagnose without knowing your set-up. Let's chat some time! I also come from a video editing background & I know enough about audio to be dangerous.
Just hijacking your video here, I have tried reaching out to you on your contact form the on website but this isnt working for some reason! You have a goldmine of info on this chanel and I was trying to get in contact to see if you could do some ad-hoc consultancy for me as I am having a mare of a job trying to get a couple of queries going!
@basensei8699
3 ай бұрын
Glorious ! Thank you indeed! And Sure thing contact me on jamesbotes@basensei.com :)
Love the video's, I learn a lot, but I keep thinking there is something wrong with earbubs, I only hear him out of the left ear bud if he plays Any other sounds it is fine, so it get annoying with the bad audio sorry if I sound like at troll
@MrJamesbotes
4 ай бұрын
Damn I didn't know that ! I think it might be my mic ! Thank you for letting me know !
@basensei8699
4 ай бұрын
thanks for letting me know man i really didnt even know about this until now!