As promised, here is Part 2 of Query Parameters in Power Query. My last blog demonstrated how
Category Archives: Business intelligence
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
Grouping in Power Query; Getting The Last Item in Each Group | RADACAD
Free data visualization with Microsoft Power BI: Your step-by-step guide | CIO
This step-by-step guide, including video, shows you how to analyze a file with more than two million records of U.S. airline flight delays using Microsoft’s free Power BI platform.
Πηγή: Free data visualization with Microsoft Power BI: Your step-by-step guide | CIO
Make Your Numeric Division Faultless in Power Query | RADACAD
Computing New Customers in DAX – SQLBI
Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI
Power Query Not for BI: Event Date and Time Scheduler – Part 1 | RADACAD
Creating M Functions From Parameterised Queries In Power BI – Chris Webb’s BI Blog
Query parameters are, in my opinion, one of the most important features added to Power BI recently. The official blog post describing how to use them is great (read it if you haven’t done so alread…
Πηγή: Creating M Functions From Parameterised Queries In Power BI – Chris Webb’s BI 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