Power BI Power Query: Range to List for Dimension Table with Functions SPLITTER and LIST.NUMBERS

Опубликовано: 16 Октябрь 2024
на канале: Mike YU (BI&Analytics)

897

In this video I demonstrate a way on how to shape a Dimension table by converting the range value into the list value in rows with power query function list.Numbers.
This video demo starts from importing the source tables from a web site in power BI desktop file, select, transfer and combine two target tables and finally end up to get two type Dimension tables for same data content.

References:

List.Numbers - PowerQuery M | Microsoft Learn
https://learn.microsoft.com/en-us/pow...

Splitter.SplitTextByDelimiter - PowerQuery M | Microsoft Learn
https://learn.microsoft.com/en-us/pow...

For more info of my BI & Analytics, please refer to the following website links:

My BI & Analytics Website:
https://sites.google.com/view/mikegua...

My blog website :
https://mikeyu.lovestoblog.com/