Power Query IF and IF AND statements
How to write an IF AND ELSE statement in Power Query and Power BI, showing syntax and examples.
Power Query
Power Query dynamic Excel worksheet name
Purpose: use a dynamic Excel worksheet name for a Power Query or Power BI data source When linking to data in another Excel workbook, you may want to update the worksheet name containing your data source, without having to update the Power Query steps. Here’s how to create a dynamic Excel workbook sheet reference for a Power Query data source. Links to sections on this page Overview of steps Store
Power Query dynamic file path
Use cell references in an Excel worksheet to create dynamic file paths for Power Query data sources. See how to name cells in Excel, and create custom objects in Power Query.
Power Query concatenate text and numeric data
How to concatenate in Power Query, combining text columns, and text with data columns. Steps in how to import data and enter formulas in Power Query.
Get started with Power Query – connect to data and add an Index
Short videos and step by step guide on how to get started with Power Query – connect to data and add an Index column.