Tag Archives: Power Query
Analyzing events with a duration in DAX – SQLBI
This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date
Power BI Desktop Query Parameters, Part 1
This article shows you how to create dynamic data sources using Power BI query parameters. You also learn how to use query parameters in Filter Rows.
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
In this article, Alberto Ferrari describes a new efficient way to compute returning customers in DAX thanks to an idea suggested by a student attending an O
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
RSS
SL Galaxy
Facebook
Google+
LinkedIn
Twitter
