Combination of rows of tables list in Power Query – Ivan Bond’s blog

Recently I faced interesting Power Query problem. Actually, initial problem has nothing related to Power Query. I required to export quite big volume of data from SAP BW using Business Objects Anal…

Πηγή: Combination of rows of tables list in Power Query – Ivan Bond’s blog

Pass Parameters to SQL Queries – The Ken Puls (Excelguru) BlogThe Ken Puls (Excelguru) Blog

One of the questions I get quite frequently is how we can pass parameters to SQL queries, allowing us to make them dynamic. Someone asked a question in the forum on the topic, so that finally inspired me to write … Continue reading →

Πηγή: Pass Parameters to SQL Queries – The Ken Puls (Excelguru) BlogThe Ken Puls (Excelguru) Blog

Conditional Code Branching in Power BI Query: if…then…else => then…else…if | Avi Singh | LinkedIn

If…Then…Else in a Custom Column We have all used an “if…then…else” statement, when adding a custom column in Power BI query (using Excel Power Query, or Power BI > Get Data). Here is a quick example

Πηγή: Conditional Code Branching in Power BI Query: if…then…else => then…else…if | Avi Singh | LinkedIn