Reformat Reports with Power Query - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 5
--u
thank you for your sharing! it's so very useful for me to study! but i also have a question. it's so good when we have 2 rows (names and entitlement) but in the case, a name with 2 entitlements, a name with 1 entitlement. so we can not choose 2 in modulo box? how can we solve it? hope you help me.
reply
thank you for your sharing! it's so very useful for me to study! but i also have a question. it's so good when we have 2 rows (names and entitlement) but in the case, a name with 2 entitlements, a name with 1 entitlement. so we can not choose 2 in modulo box? how can we solve it? hope you help me.
reply
Ian
Many thanks, Mynda. Useful techniques with index and modulo.
I'm just catching up with this 5-year-old video! This must be an older version of PQ where it doesn't always show the data type symbol on the left of the header, or is that a setting you can control?
reply
Many thanks, Mynda. Useful techniques with index and modulo.
I'm just catching up with this 5-year-old video! This must be an older version of PQ where it doesn't always show the data type symbol on the left of the header, or is that a setting you can control?
reply
knikl
Hi Mynda, thank you for posting the videos, they are very helpful. I added a custom column = if [Value]=--None- then [Entitlements] else null and then I used the fill down and got a similar result. What do you think? Thanks
reply
Hi Mynda, thank you for posting the videos, they are very helpful. I added a custom column = if [Value]=--None- then [Entitlements] else null and then I used the fill down and got a similar result. What do you think? Thanks
reply
Adamowicz
Hallo, thx for your videos, all are very helpful.
I have one sugestion to this tutorial. You can delete -Index- column before step Pivoted Column - then will be easier and faster
Try it :)
Regards :)
reply
Hallo, thx for your videos, all are very helpful.
I have one sugestion to this tutorial. You can delete -Index- column before step Pivoted Column - then will be easier and faster
Try it :)
Regards :)
reply
Anh
This was AWESOME thank you so much!!! It really helped me solve a big workflow issue and help saved us days of works every month while prevents so many human errors!!!
reply
This was AWESOME thank you so much!!! It really helped me solve a big workflow issue and help saved us days of works every month while prevents so many human errors!!!
reply
Add a review, comment
Other channel videos
