What should be your Salary in 2020 if you work with Power BI?

The Power BI 2020 Salary survey was popular enough to get some interesting results. In this post, I am sharing the result of that survey (which is filled by the public) as a Power BI report. The report gives you an overall idea of how much the minimum, maximum, and average salary should be based Read more about What should be your Salary in 2020 if you work with Power BI?[…]

Power BI Helper December 2019 Feature Summary

December 2019 is a major update in Power BI Helper. We believe this is the biggest update we have done so far. The list of updates is big. To name a few, now we have pages, visuals and bookmarks metadata available, visual comparer, visualization tree, the reverse dependency tree, DMV execution page, and dependant calculations Read more about Power BI Helper December 2019 Feature Summary[…]

Analyzing PASS SQL Saturday data using Power BI

I use Power BI for analyzing any data! and recently realized that there is no public report about SQL Saturdays around the world, hence, I build this report. This report is using live data from SQL Saturday website. What is SQL Saturday If you don’t know what SQL Saturday is, here is some information: SQL Read more about Analyzing PASS SQL Saturday data using Power BI[…]

Power BI Salary Survey and Report 2020

Are you underpaid? or you are getting paid in the market range? If you are looking for a job, what range of salary you should be looking for? The Salary survey and the report is helpful to answer these questions. The salary survey, is a form that everyone fills, and from the result of that, Read more about Power BI Salary Survey and Report 2020[…]

DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations

Have you ever had a scenario that you need to use part of your calculation multiple times? You might go and create a table or column for that and then re-use it. However, there are times that you just need that calculation to be re-used multiple times within one place. DAX variables can help you Read more about DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations[…]

Form Processing Workflow with AI Builder- Data Transformation with Power BI- Part 3

In the last two posts, I have explained how to use AI Builder with Microsoft Automate (Flow), to do the form processing. In the first post, how to set up AI Builder has been explained, next in the second one how to use Power Automate to detect the fields in a form has been shown. Read more about Form Processing Workflow with AI Builder- Data Transformation with Power BI- Part 3[…]

Calculate Totals in Power BI: Using Iterators in DAX

The total value that you see in a table is not actually SUM of all values in that column, it is, in fact, the calculation, when there is no filter. This, however, might not be the calculation that we want sometimes. we might want this value to be the sum of values of that column Read more about Calculate Totals in Power BI: Using Iterators in DAX[…]

Same Period Last Year to Date DAX Calculation in Power BI

I have previously written about how to calculate the same period last year calculation and compare this year’s values with the last year’s values. However, sometimes, you don’t yet have the full year, especially for the current year. You might want to compare this year’s value with the last year’s value up until the same Read more about Same Period Last Year to Date DAX Calculation in Power BI[…]

Pre Concatenate List of Values in Power BI using Power Query

You can concatenate a list of values in Power BI in two ways; Using Power BI DAX functions such as ConcatenateX, or through Power Query. For some scenarios, there is an advantage in using Power Query to do the concatenation. In this blog article, I’ll explain how this works. If you like to learn more Read more about Pre Concatenate List of Values in Power BI using Power Query[…]

Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases

I have written about both types of parameters in Power BI; Power Query parameters and also the What If parameters. However, still many people are not aware that these two are different, and serve different purposes. In this blog article, I am explaining the differences between these two types of parameters, as well as the Read more about Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases[…]