Power Apps dropdown controls and radio buttons are mostly used for selection purposes like, “If you want to bind the SharePoint choice field values, you can easily use these controls to retrieve the values. Recently, I got the requirement to work with the Power Apps dropdown control where I need to change or convert the … read more…
When working with strings in TypeScript, I was required to split string by a new line in Typescript. In this TypeScript tutorial, I will explain how to do this. Different operating systems represent new lines with different characters. Windows uses a carriage return followed by a line feed (\r\n), while Unix-based systems, including Linux and … read more…
Do you need to split string by length in Typescript? In this Typescript tutorial, I will explain how to split a string by length in Typescript using various methods. There are various methods to split a string by length in Typescript: 1. Using a Custom Function One way to split a string by length in … read more…
This Power Apps article explains all the details about Modern Combobox control in Power Apps, including its key properties. Additionally, we will see how to use Power Apps Modern Combobox control with various scenarios like: We will also learn how to enable the Power Apps Modern Controls for the Canvas app. Power Apps Modern Combobox … read more…
I’m sure as an analyst, you may have once been faced with the challenge of some data with a date field in the format ‘YYYYMMDD’ (e.g., 20240306) and want to transform it to a proper date format (e.g., 06–03–2024). In this tutorial, I will show you how to change yyyymmdd to date format in Power … read more…
Did you know that using Power BI Service’s “Publish to web” option is the best approach to sharing your report with other users, whether they are members of a specified security group or the entire organisation? But when you Publish to the web in Power BI, you may face errors like “Contact your admin to … read more…
The WEEKDAY function in Power BI helps you understand and analyze your data based on the day of the week. In this Power BI tutorial, we learned what the weekday function of Power BI is and how to use Power BI Weekday function with an example. Additionally, I will explain how to utilize the weekday() … read more…
If you want to convert hours values to minutes in Power BI, it is not as straightforward as multiplying it by 60. This is because Power BI has a specific way of storing date and time values in Power BI. In this Power BI Tutorial, We will discuss how to convert hours to minutes in Power … read more…
Most of my work involves getting data from various sources, such as Excel, SharePoint lists, databases, etc. In most cases, the first step is to clean the data and make it usable for my analysis. Sometimes, when I have datasets, a column has empty spots. If I use this column in a Power BI slicer, the first … read more…
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…
Many a time, you might need to add quotes in PowerShell, like single and double quotes. In this PowerShell tutorial, I will explain how to add quotes in PowerShell. In PowerShell, when a string is enclosed within double quotes, it is subject to interpretation by the parser. PowerShell will attempt to evaluate any variable or … 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…