The SELECTCOLUMNS function simply takes some column/columns from another table and create a new table from them. For example, you can take only one column, Revenue, The syntax of SELECTCOLUMNS is simple: Smaller table = SELECTCOLUMNS(Table1;”This day revenue”;[Revenue]) It is the new table name, column name in the new table, column name in the original Read More
Month: January 2022
How to Fix “Begins with”, “Ends With”, “Contains” Missing in Power Query Filter
If you use PowerQuery (if you don’t learn as quickly as possible), you may notice that in the filter, some of the options you want to use seem to be missing. So why is ‘ Begins with, Ends With, Contains ‘ missing from some PowerQuery filters? In the example below I want to remove any Read More
How to Use “IF”, “ELSEIF”, “ELSE” and “IF NOT” in Excel VBA
VBA If Statement Ref: https://www.automateexcel.com/vba/else-if-statement