How to get year and month from date in Excel Power Query, including how to create the steps in Advanced Editor.
How to write an IF AND ELSE statement in Power Query and Power BI, showing syntax and examples.
How to create a Power Query using a dynamic Excel worksheet name for the data source, with examples and guided steps.
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.
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.
Short videos and step by step guide on how to get started with Power Query – connect to data and add an Index column.