How to Filter Current Year Data Using Power BI DAX?

Filter Current Year using Power BI Dax

Recently, I was working on a Power BI report and needed to filter data for the current year. This is a common requirement for many reports, as it helps in analyzing and visualizing data to the ongoing time period. To achieve this, we can use DAX (Data Analysis Expressions) in Power BI to dynamically filter … read more…

Cascading Dropdown in Power Apps [4 Various Examples]

cascading dropdown in powerapps from sharepoint list

In this Power Apps tutorial, I will explore how to create a cascading dropdown in Power Apps using different ways. Such as: Cascading Dropdown in Power Apps [Manually] Power Apps cascading dropdown is mostly useful when you have data that is related hierarchically. To create a cascading dropdown in Power Apps manually, we will use … read more…

How to Use DATEDIFF() in Power BI DAX? [With Conditions]

power bi datediff between two columns

Last week, while working on a Power BI dashboard, I needed to calculate the difference between two dates using DAX. I researched this and found that the Power BI DATEDIFF() function is the best option for this purpose. In this Power BI article, I will explain the Power BI DATEDIFF() function and its syntax. We … read more…

How to Create CSV File in SharePoint Using Power Apps?

export gallery to excel powerapps

Recently, I got an opportunity to work on creating a CSV file in SharePoint using Power Apps. In this Power Apps tutorial, I will explain in detail information about how to create CSV file in SharePoint using Power Apps with a real-time scenario. Also, we will see how to export gallery data to excel in … read more…

Power BI DAX Date Filter Not Working [3 Main Reasons & Its Solutions]

Power BI Relationships Not Set

When working with Power BI, you might encounter issues with date filters that do not work as expected. There can be various reasons for this, such as incorrect DAX formulas, wrong date formats, an improperly set date table, or missing relationships between the date table and data table. Below, I will present some common problems … read more…

Set Field Value From Another Field In Power Apps [5 Examples]

powerapps onchange update another field

When working with Power Apps applications, we can usually build an app using different fields and set a field value based on another field. In this Power Apps tutorial, I will show you working with Power Apps set text input value based on another field and how to use the Power Apps onchange update another … read more…

13 Various Power Apps Choices Function Examples

Power Apps Choices Function

Recently, I have worked on the Power Apps Choices() function to get all the choices from my SharePoint Online list. Additionally, I displayed the choice field values on the Power Apps Dropdown control. In this Power Apps tutorial, I will explore all the information about the Power Apps Choices function like, what the Power Apps … read more…

How to Filter Distinct Date Using Power BI DAX?

power bi distinct count with date filter

Sometimes, you may need to display unique dates from a dataset in a Power BI report. You can create a calculated table or column that filters out duplicate dates to do this. Let’s look at an example of how to filter distinct date using Power BI DAX. Filter Distinct Date Using Power BI DAX While … read more…

How to Sort Power Apps Combo Box Items [6 Various Ways]

power apps combo box items sort

I recently created a Power Apps form with a combo box control containing country names as items. To reduce the search time, I sorted the combo box items alphabetically. Users can scroll through the combo box items based on the first letter and easily select their country name. In this article, I will explain the … read more…

How to Create Power Apps Quiz App?

power apps quiz template

The Power Apps quiz app means it is a survey app that contains single or multiple questions where each question has multiple-choice options. You can follow this complete Power Apps tutorial to get an idea to create a PowerApps quiz app with a simple scenario. Power Apps Quiz App The Power Apps Quiz App is a user-friendly … read more…

Create a New Table From an Existing Table in Power BI

Power bi create a table from another table using DAX example

Sometimes, you may receive a requirement to create a new table from an existing table in Power BI. This task can be for various reasons, such as organizing data more effectively or preparing it for specific analyses and visualizations. So, I thought to show you how to create a table from an existing table in … read more…

How to Upload File to SharePoint Document Library using Power Apps?

power apps upload file to sharepoint document library

While working with the SharePoint Online document library, we sometimes need to upload a file or multiple files from Power Apps to the SharePoint document library. In this Power Apps tutorial, I will explore in detail information about upload files from Power Apps to the SharePoint document library including: Power Apps Upload File to SharePoint … read more…

How to Bind SharePoint Lookup Column in Power Apps Dropdown?

how to get sharepoint lookup column values into power apps dropdown

A few weeks ago, I received a requirement in Power Apps to filter the gallery items based on dropdown lookup values. All the dropdown values must be retrieved from the SharePoint list lookup column. In this article, I will show you how to bind SharePoint lookup column in Power Apps dropdown. Also, how to filter … read more…

6 Easiest Ways to Filter Gallery in Power Apps

powerapps gallery filter

Power Apps filter gallery is a common daily requirement for all users. We can filter gallery in Power Apps based on the text column, choice column, person, and so on. In this article, I will explain how to filter gallery PowerApps, how to filter gallery based on text input Power Apps, and many more like: … read more…

Power Apps functions free pdf

30 Power Apps Functions

This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.

Live Webinar

SharePoint Permission Checker Agent using Microsoft Copilot Studio

Learn how to build a SharePoint Permission Checker Agent using Copilot Studio. Using this agent, you can check library-level and file-level permissions. Also, identify Users, SharePoint Groups, and Permission Levels.

📅 1st July 2026 – 10:00 AM EST | 7:30 PM IST

Download User registration canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App