I am working on a report for an organization, and I faced a requirement to identify and handle blank values in Power BI reports. Several columns contained empty data, which we did not want to consider in reports. Power BI provides multiple DAX functions, such as ISBLANK, COALESCE, FIRSTNONBLANK, and LASTNONBLANK, to identify, remove, or … read more…
One of my colleagues asked me how to join the First Name and Last Name columns in Power BI and add a space between them. He had tried creating a calculated column using the following DAX formula: However, this caused an error because the CONCATENATE function in DAX only accepts two arguments in the format … read more…
One of my colleagues asked me how to check if a text value is a date in Power BI Power Query. He was working on a report where a date field was stored in text format. When he tried to change the column data type to Date, Power BI showed errors for some rows. The … read more…
While working on Power BI reports for clients, I noticed that the data coming from Excel, SharePoint, or databases was rarely ready for reporting. In many cases, the values I needed were not available as separate columns. Instead, I had to create new columns from existing data, such as calculating values, applying simple business logic, … read more…
While working on a client report, there was a requirement to clean and format text data before using it in visuals. The source file contained values such as codes, names, and descriptions combined into a single column. The client wanted only specific parts of the text, such as the first few characters, the last value, … read more…
While working on a client report, there was a requirement to select multiple values from a slicer instead of choosing only one value at a time. The client wanted users to filter the report easily without holding the Ctrl key, and also needed the slicer to work across different visuals and tables. To solve this … read more…
Last week, one of my subscribers asked me a question about Power Query in Power BI. He was working with a Product table that has three columns: Product Key, Date, and Sold. For one Product Key, there are many records with different dates. The requirement was simple. He wanted to count how many times the … read more…
While working on Power BI reports, I receive data from multiple tables or different data sources. Many times, the information we need is split across these tables, and using them separately can cause issues when creating table visuals in Power BI. To solve this problem, we need to merge tables in Power BI. We can … read more…
As a community contributor, I regularly write blog posts based on my real-time experience from client projects and from working on our internal products. Sometimes I write a completely new blog post, and sometimes I update an existing post with new learning and practical experience. Before writing or modifying a post on SPGuides or EnjoySharePoint, … read more…
While working on a Power BI report for a Sales team, one of my colleagues asked me how to convert numbers to text in Power BI. This was because, in the source data, one column contained both numbers and text values. When this column was used in a chart or visual, Power BI started showing … read more…
I was working on a Power BI report, and I noticed that some columns, like Employee ID, Customer Code, or Product Number, were stored as text and had leading zeros, for example, 000123. When I use this column in a report and try to sort or filter the data, I am not getting the correct … read more…
When I was working on a Power Apps and Power Automate solution to create SharePoint sites automatically, I needed it to work across any tenant. The flow creates SharePoint sites via REST API calls, so we must pass the tenant name. However, Power Automate does not provide any direct action or function to get the tenant … read more…
When building apps in Power Apps, we often need fields to store simple true/false values, such as Is Active? Is it approved? Or has Email been Sent?. In Dataverse, this type of field is called a Yes/No field. In one of my apps, I needed a simple way to track things like whether a record … read more…
When I was working on a Power Apps and Power Automate solution for a client who wanted to create SharePoint sites automatically. Users would fill in details such as site title, internal name, storage quota, description, owners, members, and visitors in Power Apps. After submitting the form, Power Automate creates the SharePoint site using a … 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