A few days ago, I was creating a dashboard for a client where they needed to analyze their data using different date conditions. They wanted to see records greater than a certain date, compare data before a specific date, and even view trends between two selected dates. Since these filters had to work dynamically inside … 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…
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…
A few days earlier, my manager asked me to send a report about who had permission (including external users) to access the files stored in the SharePoint library. This library has multiple levels of subfolders, so I need to make a report on the files present in those subfolders as well. To achieve this requirement, … read more…
Recently, I was working on an SPFx web part that would allow employees to upload their documents along with metadata to a SharePoint document library. The web part includes a form with input controls for the library columns. To help with debugging, I also displayed logs in the web part, just below the form. When … 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…
In one of my apps, I was loading data from several SharePoint lists into one collection. Since each list had different columns, the final collection didn’t always have the same structure. Before I could filter or use the data, I needed a quick way to see which column names were actually inside the collection. In … 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…
In an organization, I set up a Laptop Agreement process in which employees submit requests for laptops to work from home. These requests are stored in a SharePoint list named “Laptop Agreement.” Each request needs to be reviewed by the Releasing Officer. Once approved, the laptop allocation details must be added to another SharePoint list … 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…
A few days ago, I needed to filter a gallery based on a Dataverse Choice field. I had a dropdown in Power Apps that showed all the Dataverse choices, and whenever a user picked an option, the gallery had to filter based on that selection. In this Power Apps tutorial, I will explain how to … read more…
If you want to become a SharePoint Framework (SPFx) developer, then you should start by building your first SharePoint client-side web part. This complete tutorial will help you with this. I will explain, step by step, how to develop a SPFx client-side web part, including testing it in the workbench, packaging it, and finally deploying … read more…
Recently, while setting up a reporting dashboard for an organization, I had to work with some data that wasn’t fully clean. One of the tables had repeated values, and before using it in visuals, I needed to clean and prepare it properly. To do that, I first created a duplicate column so I could apply … read more…
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App