One day, one of my clients asked me to display the currently logged-in user name in a reverse manner in Power Apps (For example, Annie Husen -> Husen Annie). At first, I thought it was pretty tricky. But later, after researching, I found it very easy to achieve using the Power Apps Split function. In … read more…
Recently, while working with the Power Apps application, I was required to display the gallery-selected item details in a text label. I needed to make some bold text and increase the font to differentiate the details, but we can’t achieve this with a standard text label. After researching, I learned that Power Apps has a control … read more…
I developed a Power Apps application for leave management a few weeks ago. Since I had to switch between the screens there constantly, I made a left navigation component so that users could do it quickly. In this tutorial, I will explain how to create a Power Apps left navigation component step by step. Create … read more…
Last week, I created a Leave Management application. For this app, I was required to generate PDFs of employee leave requests only if the final approvers approved them. This way, employees can view their approved leave requests and download them into their system. In this article, I will explain how to generate and download PDFs … read more…
Recently, I was working on building a Power Apps application that takes data sources as a SharePoint list. To avoid creating SharePoint lists and manually adding different types of columns, I wrote a PowerShell script. While adding different types of columns to the SharePoint lists, I was required to enable and disable some of the … read more…
Last week, I built a Power Apps Leave Management application. Within that, there is a leave request form that allows the employees to request leave. Here, I was required to calculate the leave days between the start and end dates, excluding public holidays and weekends. In this article, I will explain how to calculate business … read more…
While working with the Power Apps combo box control, we might need to reset this control to undo the selection that we have made. We can reset a Power Apps Combo box to any default value or empty value. In this article, I will show you how to reset Power Apps combo box control using different scenarios. … read more…
A few weeks ago, I created an app in Power Apps for approving employee leave requests. Here, I needed to set the approval status combo box value to Approved if I clicked the Approve button and reject if I clicked the Reject button. In this article, I will explain how to set combo box value … read more…
Last week, I worked on a Power BI customer support report that required showing the number of support tickets created in the last 30 days. Also, it filters the data to show the tickets created in the previous seven days. All these things are possible by using the Power BI DAX statement. In this Power … read more…
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…
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…
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…
While working together, one of my Power BI clients wanted to filter the data between two dates or based on the date selection. I’ve found that using the Power BI DAX function is extremely easy. In this Power BI tutorial, I will explain how to filter date using Power BI DAX, Power BI DAX filter … read more…
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…