Power BI Power Query Tips: Range Lookup with Power Query M Table Function TABLE.SELECTROWS
In this video I demonstrate a way by using power query M Table function to lookup the Blood Pressure range values from one dimension table into the fact table. By the demo the power query M Table function Table.SelectRows is applied . the Microsoft lean site URL of function descriptions is attached in the references section. The syntax of the function has two input parameters. First one is a table as input, second one is a function to express selection condition. This query function finally returns a table of rows from the target table, that matches the selection conditions.
References:
Table.SelectRows - 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/
