IN operator in Power Query M code
You can check multiple values in any list using IN operator in Power Query. Lets say, you have a requirement to check for specific categories… Read More »IN operator in Power Query M code
Home »
Power Query in Power BI
Add a columns from examples in Power BI
Power Query add column from examples feature, allows you to add new columns to data model simply by providing one or more example values for… Read More »Add a columns from examples in Power BI
Unpivot Columns in Power BI
Power Query provides a feature that is Unpivot columns which allows you to transform columns into attribute-value pairs, where columns become rows. Columns that you… Read More »Unpivot Columns in Power BI
Fill values in column in Power BI
Power Query provides a FILL operation which allows you to fill up and fill down to replace null values with the last non-empty value in… Read More »Fill values in column in Power BI
Import text using examples feature Power BI
Power BI August 2020 update has released a new feature Import text using examples, which allows you to import text/csv file which allows you to… Read More »Import text using examples feature Power BI