Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Power Query: Get Running Occurrence Count using List.Generate. That video is uploaded by Josh_Excel at 2023-03-01T14:21:34-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [Zg6CpZ12JY4]
| Name | Power Query: Get Running Occurrence Count using List.Generate |
| Video Uploader | Video From Josh_Excel |
| Upload Date | This Video Uploaded At 01-03-2023 22:21:34 |
| Video Discription | #powerquery #power_query Starting Table: = #table({"Name"}, {{"a"},{"a"},{"a"},{"b"},{"b"},{"b"},{"c"}}) Full Advanced Editor Code (Will need to add Greater and Less Than Symbols instead of ˂˃): let Source = #table({"Name"}, {{"a"},{"a"},{"a"},{"b"},{"b"},{"b"},{"c"}}), List = Source[Name], List2 = List.Generate ( ()=˃ [Counter = 1, Occ = 1], each _[Counter] ˂= List.Count(List), each [Counter = _[Counter] + 1, Occ = if List{_[Counter]} = List{_[Counter]-1} then _[Occ] + 1 else 1], each _[Occ] ), #"Added Index" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type), #"Added Custom" = Table.AddColumn(#"Added Index", "Occurance", each List2{[Index]}), #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Index"}) in #"Removed Columns" Zg6CpZ12JY4 |
| Category | People & Blogs |
| Tags | People & Blogs Download MP4 | People & Blogs Download MP3 | People & Blogs Download MP4 360p | People & Blogs Download MP4 480p | People & Blogs Download MP4 720p | People & Blogs Download MP4 1080p |
