When working with Power BI or Excel through Power Query, you may encounter scenarios where you need to filter SQL Server data using a list of values. For instance, you may want to dynamically load only records that match a list of customer IDs, product SKUs, or regions. This is typically done using the SQL WHERE … IN (…) clause. However, passing a list of […]
Some thoughts about correctly naming your Power Query steps, to improve readability and contextualize your data, so you can make sense of the process just by looking at the step names.
Hi Power BI Folks! Welcome to our very first blog post here at daxproservices.com. This will be the start of a great journey of Power Platform posts together. I just wanted to share a tip that will help you save some steps while writing your Power Query queries, especially if you are not familiar with M formulas and the Advanced Editor. Goal We are going […]