itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Power BI: filter using another table before loading data

Before loading the data, I may filter to not import all of them, normally, I used to remove blank/empty values but sometimes, I may want to exclude for instance, 2 specific values, so it is quite simple but what happens if my excluding list is huge !!!

In such situation, I will use a table and the merge queries option. I have this main table called table1:

power bi

And this table called table2 with the particular values:

power bi

How can I exclude or load only those specific values ? But before to begin, to code in “advanced editor”, I can declare them like that:

Listvalue = Text.Combine(yourtable[yourcolumn], ", "),

power bi

NOTE: for more information, read Power BI: combine multiple values

Going back to the main subject, from the Power Query Editor, I will select table1 then I will click on this option:

power bi

From here, the process will be different if I want to exclude or to load table2.

Excluding option

For this option, make sure to select like in the picture the “join kind” field:

power bi

From the result, I can remove or keep the “table2” column:

power bi

Loading option

For this option, make sure to select like in the picture the “join kind” field:

power bi

From the result, I can remove or expand the “table2” column to get the “status”:

power bi
power bi

Interesting Topics