Bijay Kumar 
If you use Power BI DAX (Data Analysis Expressions), you might encounter the NaN Error when dividing the column. In this short tutorial, I will show you how to quickly solve this error in Power BI (using some easy DAX tricks). I will also show you how to solve NaN error in Power BI with … read more…
The foreach statement and the ForEach-Object cmdlet, while similar in function, difference in form, execution context, and performance implications. They are both designed for iterating over collections, executing a block of script code for each object in the collection. In this PowerShell tutorial, we will explain everything about the Foreach vs Foreach-Object in PowerShell. What … read more…
A Power BI visual becomes difficult to read without data labels. At the same time, adding data labels in Power BI visualization is a good practice. Many analysts often include data labels in their visuals. You might wonder what a data label is in Power BI. Don’t worry. In this Power BI tutorial, we will … read more…
Recently, I got a requirement to work with the Power Apps data table sum column, and we can achieve it by using the Power Apps Sum() function. In this Power Apps tutorial, I will show you how to sum column in Power Apps Data table control. How to Sum Column in Power Apps Data Table … read more…
Suppose you want to filter the Power Apps data table using dropdown. In that case, you can follow this tutorial to get all the information about how to filter Power Apps data table by dropdown. Here, we will discuss filtering the Power Apps data table by dropdown using the collection and SharePoint Online list. Also, … read more…
Power BI is a great tool for data analysis. When people first learn Power BI DAX (Data Analysis Expressions), they often begin with basic arithmetic calculations like addition, subtraction, multiplication, and division. In this tutorial, I will demonstrate how to subtract in Power BI using DAX (Calculate column, Measure). We will also discuss how to … read more…
Power BI can be quite useful when we are working on dates. It has some powerful built-in formulas that allow you to do calculations based on dates. One common scenario where you have to perform calculations with dates would be to find out how to calculate monthly sales. In this tutorial, we will learn how … read more…
This Power BI tutorial will help how to add data to existing table in Power BI. Recently, while working on a Power BI report, I encountered a situation where I needed to add data to an existing table. The Append feature in the Power Query Editor of Power BI proved very helpful in this scenario. … read more…
Power Apps is a powerful platform developed by Microsoft that allows users to create custom business applications using different types of controls like Text inputs, Dropdown, Forms, Gallery controls, etc. While working with the dropdown control, we sometimes need to validate if a dropdown is empty or not in Power Apps; if it is empty, … read more…
If you are having trouble organizing your data in Power BI, the Power BI measure table can be helpful. In this Power BI tutorial, we will look at the idea of a Power BI measure table, how to create a measure table in Power BI, and how to add the measure to the measure table … read more…
Sorting columns is common when working with Power BI tables and matrix visuals. It helps in organizing and presenting data in a more meaningful way for analysis. But what if you want to Sort Multiple Columns in Power BI? Sorting columns in Power BI tables and matrix visuals might differ from other software, but you … read more…
While working with the Power Apps Dropdown control, we usually need to filter the data like SharePoint list records, Collection records, and Excel items based on the dropdown selected value. But, sometimes, we need to add an “All” option to a dropdown in Power Apps that allows users to display all the records on the … read more…
Power Apps dropdown controls are mostly used to collect user input, such as selecting a category, product, or value from a SharePoint list. A common scenario involves using a dropdown control in PowerApps to display a list of users from a SharePoint person or group field. Follow this tutorial to get all the information on … read more…
If you are working in PowerShell, then you will get requirements to use looping to iterate items in a collection. In this tutorial, I will explain how to use PowerShell foreach loop with various real examples. The foreach loop in PowerShell takes a collection of items and iterates over each item sequentially. It assigns each … read more…
Enroll now and get access to all 9 academy courses at no extra cost.
Secure your seat before the batch fills up.
Get the live training plus the complete SPGuides.Academy learning library.
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Learn how to build an invoice management system using SharePoint integration and a repeating table.
📅 2nd September 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App