Tag Archives: Power Query
Analyzing events with a duration in DAX – SQLBI
Power BI Desktop Query Parameters, Part 1
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
Callum | Query Parameters in Power Query – Part 2
As promised, here is Part 2 of Query Parameters in Power Query. My last blog demonstrated how
DAX coding style using variables – SQLBI
This article shows how variables in DAX can impact the coding style, simplifying a step-by-step approach and improving the readability of your code. The ne
Computing New Customers in DAX – SQLBI
Power Query Not for BI: Event Date and Time Scheduler – Part 1 | RADACAD
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