Resources   No resource found

• Using the With() Function to Improve Formulas in Power ApplicationsMar 12, 2026. Simplify Power Apps formulas with the With() function! Learn how to reduce repetition, improve readability, and enhance maintainability for efficient app development.
• What Causes Excel Formulas to Recalculate Unexpectedly in Large Workbooks?Jan 19, 2026. Tired of Excel slowing down? Discover the hidden culprits behind unexpected recalculations in large workbooks and learn how to optimize performance for smoother workflows.
• Create and Explain formulas with Copilot (AI) in Power PlatformFeb 10, 2025. Discover how Copilot in Power Platform simplifies Power Fx formula creation and explanation using natural language. Speed up Power Apps development with AI-powered assistance for generating and understanding complex formulas.
• Explain Named Formulas in Power AppsJun 28, 2024. Learn how to leverage named formulas effectively in Power Apps with our comprehensive guide. Explore the benefits of named formulas for organizing and reusing logic across your applications. Master the creation, management, and application of these formulas to streamline development and enhance app functionality.
• Essential DAX Formulas for Power BI BeginnersMar 07, 2024. Master essential DAX formulas in Power BI for effective data analysis. Learn fundamental functions like SUM, CALCULATE, RELATED, AVERAGEX, and IF with illustrative examples for actionable insights.
• How To Use Formulas And Functions In PowerApps(Power Fx)May 04, 2022. In this Article wea re going to see about what PowerApps Formula reference and how it is useful to develop Power Platform Applications.
• Use Copilot to Create and Edit Power Fx formulasJun 02, 2025. Copilot is an AI feature in Power Apps Studio that helps you create and modify Power Fx formulas quickly. You can use Copilot in the formula bar to explain Power Fx formulas in natural language or generate Power Fx formulas from natural language or code comments.
• Exciting New Features in PowerApps: Named FormulasJun 28, 2024. Discover the latest enhancements in PowerApps, including the powerful Named Formulas feature. This blog post walks you through enabling and using Named Formulas, which streamline app development by allowing you to define and reference values consistently across your app.
• Implementing Proper Theming in Power Apps Using OnStart (Beginner to Advanced Guide)Apr 21, 2026. This article explains how to implement a centralized theming approach in Power Apps using the App OnStart property. Instead of hardcoding styles, you’ll learn how to create reusable theme variables and apply them across your app for a consistent and maintainable UI. It also covers dynamic styling, hover effects, and best practices to build clean, scalable, and professional Power Apps applications.
• If() vs Switch() Functions in Power AppsApr 03, 2026. Master PowerApps formulas! Learn when to use If() vs. Switch() for efficient and readable code. Explore examples and best practices for optimal performance in your apps.
• Simplifying Multi‑Value Comparisons in Power Apps with the in OperatorMar 18, 2026. Simplify Power Apps multi-value comparisons using the 'in' operator! Replace complex OR conditions with concise arrays for cleaner, scalable, and maintainable code.
• How to Fix Delegation Warnings and Handle 10,000+ Records in Power Apps with SharePointFeb 26, 2026. Delegation issues can break your Power Apps solution when working with large SharePoint lists. This article explains why delegation warnings occur and provides a practical, step-by-step solution to build scalable, high-performance apps without data loss.
• How to Use Copilot to create a formula from a discrete request in PowerAppsFeb 26, 2026. Unlock PowerApps formula creation with Copilot! Learn how to use natural language to generate Power Fx expressions for galleries, buttons, and more. Boost productivity!
• How to Use User Defined Function (UDF) in Power AppsFeb 17, 2026. Master Power Apps User Defined Functions (UDFs)! Learn to create reusable formulas, simplify complex calculations, and build scalable, maintainable apps. Examples included!
• How to Use SharePoint Calculated ColumnsFeb 12, 2026. Automate calculations in SharePoint lists using calculated columns! Learn to create dynamic formulas for text, numbers, dates, logic, and more. Boost productivity!
• Power Apps Quick Functions – A Simple GuideJan 05, 2026. Power Apps functions are built-in formulas that help developers control how an app works. These functions are used to handle logic, manage data, control user actions, and improve the overall user experience. They allow you to build powerful applications with minimal code by defining what should happen when users interact with the app.
• How to Use With() Function in Power AppsJan 01, 2026. Master the Power Apps With() function! Simplify complex formulas, create temporary variables, and enhance readability. Explore 15 practical examples for efficient coding.
• Finding the Centroid of a Polygon: Powering Real-Time Wildfire Response SystemsOct 12, 2025. Discover how to calculate the centroid of a polygon using the shoelace formula in Python, with a focus on its critical role in real-time wildfire response systems. Learn to implement a robust centroid calculator, validate results, and handle edge cases. Explore best practices for geospatial applications, including coordinate systems and degenerate shapes. See how this geometric calculation aids emergency teams in placing command posts and predicting fire spread, ultimately saving lives and property.
• User-Defined Functions (UDFs) in Power AppsOct 03, 2025. Discover Power Apps User-Defined Functions (UDFs), an experimental feature for creating reusable formulas. Learn how UDFs enhance modularity, simplify maintenance, and clean up complex logic in your canvas apps. This guide covers enabling UDFs, creating functions with parameters and return types, and calling them within your app. Note: UDFs are currently in preview and not recommended for production apps due to potential instability and limitations.
• How to Interpolate Using Lagrange’s Interpolation Formula in Python Oct 03, 2025. Unlock the power of Lagrange's Interpolation Formula in Python! This article provides a step-by-step guide, real-world examples (like environmental air quality monitoring), and a robust Python implementation with error handling. Learn when to use (and avoid) this elegant technique for estimating values between known data points. Perfect for small datasets and educational purposes. Discover practical tips and best practices for effective usage.
• Write Prompts for Data Analysis and Excel Work with AIAug 23, 2025. AI can analyze data, generate formulas, and automate Excel tasks — if you write the right prompts. Learn prompt engineering techniques for data analysis and spreadsheet automation.
• Beginner’s Guide to Power BI: DAX, Measures, and Learning by DoingAug 07, 2025. I’m still new to Power BI, but I’ve already learned a lot... and I’m still learning! Especially about DAX formulas, measures, and how they’re different from Excel. This post is my beginner-friendly take on what clicked, what confused me, and how I’m figuring it out along the way.
• Use the Navigate Function for Seamless Transitions in Power AppsJan 01, 2025. Learn how to use the Navigate function in Power Apps to create smooth user experiences by enabling seamless navigation between screens. This article covers basic navigation setup, custom transitions, and how to pass context between screens.
• Exploring Formula-level Error Management in PowerAppsJul 03, 2024. In this article, we explore Formula-level Error Management in PowerApps. Learn how to enable this feature and improve app usability by creating custom errors and gathering valuable error information. Understand how to use the Error function, manage specific error types, and utilize FirstError for better error handling.
• What is Verhoeff AlgorithmMay 05, 2024. In this article we will learn about verhoeff algorithm. The Verhoeff algorithm, devised by mathematician Jacobus Verhoeff, ensures numerical data accuracy by detecting digit transpositions. It employs permutation tables and multiplication to produce a checksum for validation.
• Flexible Height Gallery with a SeparatorApr 01, 2024. Learn to create a flexible gallery with a separator in your app.Add a blank flexible height gallery. Add controls like labels and dropdowns.Set auto height toggle for labels.Add separator rectangle with Y property formula. Easily enhance your gallery with this guide.
• Land Area Calculation with Heron's Formula in C#Mar 12, 2024. In this article, we'll explore how to utilize Heron's formula, a geometric approach, to calculate land area using a straightforward C# program. This program empowers users to input side lengths of adjoining triangles and effortlessly determine the total land area.
• Fromula-Based Columns in Dataverse TablesMar 05, 2024. This content discusses the concept of formula columns in Microsoft Dataverse tables, highlighting their functionality in displaying calculated values using Power Fx, a user-friendly programming language. It provides steps on how to add a formula column and explores various use cases and limitations associated with this feature.
• Workweek Date Calculation for Start, End, and Due DatesMar 04, 2024. This article provides guidance on displaying the start and end dates of working weekdays in a Time Sheet App built in PowerApps. It outlines steps to set up a dropdown for week selection, determine the start date for Monday, and define the end date for Friday based on the selected week.
• Excel Formula: Generate Random Dates and Extract Day, Month, Year, QuarterFeb 05, 2024. This article shows how to Generate Randomised Dates and Extract Day, Month, Year, and Quarter using a Single Formula in Excel. Explore advanced Excel formulas using the LET function and dynamic arrays to generate 100,000 rows of randomized dates.
• How To Use FIRSTN,LASTN And INDEX Formula In Canvas Apps (Power Fx)May 14, 2022. How to use FIRSTN,LASTN and INDEX  Formula in Canvas APPs (Power Fx)
• How To Use AddColumns, RenameColumns, DropColumns, ShowColumns Formula In Canvas APPs(Power Fx)May 12, 2022. How to use ADD COLUMNS ,DROP COLUMNS, SHOW COLUMNS and RENAME Columns Formula in Canvas APPs (Power Fx)
• How To Get Correlation Coefficient In Power BIJan 13, 2021. This content explains Pearson's correlation coefficient, the most widely used correlation coefficient, particularly in linear regression and measuring the relationship between two variables. Interpretation of correlation coefficient values and provides step-by-step instructions.
• How To Learn Power BI And How Long It Takes To Learn Power BIDec 08, 2020. Power BI, a powerful business intelligence tool by Microsoft, transforms raw data into actionable insights through reports and dashboards. Learn essential skills like data visualization, modeling, and DAX formulas. Master Power BI within 30 days with structured learning modules covering installation.
• Development Of An Information System Using Microsoft PowerApps - Part ThreeJun 22, 2020. In this article, we connect the data with its corresponding Share Point List using some PowerApps formulae and functions.
• Some Important Formula For App Development In PowerAppOct 04, 2018. In this article, I am going to explain some important and useful formula to develop an app in PowerApp.
• Learn SharePoint In Series - Part Eight - Validation Settings In List SettingsJun 11, 2018. This article delves into the list validation settings in SharePoint, elucidating their importance and practical applications. It provides step-by-step guidance on configuring validation settings at the list level, along with examples and benefits of utilizing such settings.
• Set Validation Formula for Lists in SharePoint 2016 and Office 365 Using JavaScript Object ModelJun 28, 2016. In this article, you will learn how to set validation formula for Lists in SharePoint 2016 and Office 365 using JavaScript Object Model.
• Excel Tips n Tricks : Tip 7 (Generating List of Filenames in Excel 2013)Jul 27, 2013. This article will help you to learn how to get the file names inside any folder/directory.
• How to Create Custom Expiration Formula in SharePoint 2010Nov 29, 2012. In SharePoint 2010, we can set an expiration date for documents so that when the expiration date is reached a specified action is performed.
• Mathematical Formula in Word 2013Oct 23, 2012. This article describes the use of mathematical formulas in a Word table.
• Formula For Computed Column Specification Property in SQL Server 2012Oct 10, 2012. This article will give you an idea of how to use formula child property of computed column specification property in SQL Server.
• Crystal Reports: Save Time with Formula SharingFeb 15, 2010. In this article you will learn how to use Crystal Reports: Save Time with Formula Sharing.
• Crystal Reports: 5 Tests for Top PerformanceFeb 10, 2010. In this article how to use Crystal Reports: 5 Tests for Top Performance.
• Creating a Dynamic Excel Using HTMLAug 30, 2007. This article includes some sample programs to show how to implement various excel functionalities with the help of HTML.
• Formatting Dates in Crystal ReportsJun 14, 2007. Formatting a formula with a date value could be tricky in Crystal Reports. This article shows how to format date fields and date formulae in Crystal Reports.
• Alternate Row Color in Crystal ReportJun 07, 2005. This article shows how to develop reports with alternating row colors.
• Formula Generator - A Regular Expression Generator Class in C# and .NETAug 17, 2004. The attached source code is a class - FormulaGenerator, which is a component that interprets and evaluate a string expression
• Formatting Chemical Formulae in DataGridSep 25, 2003. In this article we'll see how to format chemical formulae in DataGrid Web Server Control.