Last week, one of my subscribers asked me a question about filters in Power BI. They have a budget table with budget values for all 12 months, and actual values for only 9 months. They wanted to create a DAX measure that shows the full-year budget even when the Month filter is selected on the … read more…
Today, I received an email from a user who wanted to create a DAX measure to count how many distinct companies sold 10 or more items in a week. They wrote a DAX formula like this: Count above 10 =CALCULATE( DISTINCTCOUNT(Table1[Company]), FILTER(Table1, SUM(Table1[Items sold]) >= 10)) But this did not work. The reason is that … read more…
While working on one of my Power BI reports, I realized my dataset wasn’t in the format I needed. After applying filters and validation rules, I wanted to add a column with a fixed value for each row. So, I started researching and found that Power BI offers multiple ways to add a fixed-value column, … read more…
When working with Power BI for my client, I need to filter rows based on the value in another column and create a separate table. To do this, we need to use the Filter() function, then, based on a condition, create a table. In this post, I will share how I filter data in Power BI using … read more…
In my organization, when I am creating a Power BI dashboard, and many times I need to add new columns based on different conditions. Sometimes I must check multiple rules, use AND/OR, or handle errors in the data. I also need to add a column only if it doesn’t already exist. Power Query makes all … read more…
When working with Power BI, I need to check if a column contains a specific word or value and then create a new column based on that. At first, I struggled with this because there are many different “contains” scenarios in Power Query. After working on e-commerce dashboard projects, I learned some easy, reliable ways … read more…
In my organization, I am creating a Power BI dashboard, and I often encounter columns with blank or null values. These empty fields can cause issues in calculations and visuals. To fix this, I started using Power Query and DAX to check for blank or null values and create clean, meaningful columns. In this tutorial, … read more…
Recently, while creating an HR dashboard in Power BI, I encountered a situation in which one table had an important column I also needed to use in another table. Instead of manually copying data, I explored different ways to bring that column into the second table. In this tutorial, I will show you how to … read more…
When I was working on an Expense Reimbursement application, I realized something important: the approver can’t make a proper decision just by looking at basic details. They need to see the actual invoice, bill, or receipt before approving the request. Without these attachments, the approval process becomes slow, confusing, and sometimes even incorrect. To avoid … read more…
