Resources   No resource found

• How to Implement Soft Delete in SQL Server Using Flag ColumnsMay 04, 2026. Implement soft delete in SQL Server using flag columns for data preservation, audit trails, and recovery. Learn best practices, advantages, and real-world use cases.
• How to Dynamically Add Choices in SharePoint Choice Column using Power AutomateApr 30, 2026. Learn how to dynamically update SharePoint choice columns with Power Automate! This tutorial uses _api/contextinfo to automate choice options, saving time and ensuring accuracy.
• SharePoint Lookup Column Threshold in PowerApps Custom FormsApr 06, 2026. Overcome the SharePoint lookup column threshold in PowerApps! Learn why it happens and how to fix it by simplifying forms and data structures for optimal performance.
• How to Add Theme Switcher in Web Apps (Light, Dark & Custom Colors)Mar 24, 2026. Explore column themes for web design! Customize backgrounds with white, black, pink, blue, or yellow. Enhance user experience and accessibility. Learn how!
• What Are the Different Types of NoSQL Databases?Mar 11, 2026. Learn the four main types of NoSQL databases including document, key value, column family, and graph databases. Understand their architecture, use cases, and real world examples.
• Understanding Indexed Columns in SharePointMar 11, 2026. Optimize SharePoint list performance! Learn how indexed columns speed up filtering, sorting, and queries in large lists, bypassing the 5,000-item threshold. Improve PowerApps & Automate flows.
• 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 Fix “Cannot insert NULL into column Srno” When Srno Must Be Auto-Increment (SQL Server)Feb 27, 2026. Fix "Cannot insert NULL into column 'Srno'" in SQL Server when Srno should auto-increment. Learn a production-safe solution involving temporary tables and foreign keys. Avoid data loss and table name changes!
• How to Fix Patch Not Working & Duplicate Records in Power AppsFeb 27, 2026. Solve Power Apps Patch issues! Prevent duplicate records and silent failures when saving data to SharePoint. Learn to update or create records reliably using LookUp. In real-world Power Apps projects, Patch failures and duplicate SharePoint records are common challenges that impact data integrity and user experience. This article explains the root causes behind these issues and how to handle them effectively. Learn practical techniques like proper form validation, conditional Patch logic, and duplicate checks. A real-world scenario walkthrough makes it easy to implement these solutions in your own apps.
• How to Filtering a SharePoint Choice Column at the App LevelFeb 27, 2026. Control SharePoint Choice column options in Power Apps without modifying the list! Filter choices based on user roles for tailored dropdown experiences. Keep your data clean!
• Preprocessing Framework for Retrieval-Augmented Generation (RAG)Feb 24, 2026. Master RAG preprocessing: chunking for consumable data, embeddings for semantic comparison, and metadata for contextual filtering. Build better LLM apps!
• How to Configure and Use Validation Settings in SharePointFeb 20, 2026. Master SharePoint validation! Learn to configure column & list validation for data accuracy. Enforce rules, prevent errors, and improve data quality in SharePoint lists.
• Modern Metadata Management Strategy for EnterprisesFeb 19, 2026. Unlock data's potential! Modern metadata management drives discovery, governance, and compliance. Build a scalable strategy for enterprise success. #DataGovernance
• How to Get Image from a SharePoint Image Column Using Power AutomateFeb 18, 2026. Struggling to extract images from SharePoint image columns in Power Automate? This guide provides a simple solution to retrieve and use those images in your flows. Learn how to access image data and automate image extraction for email attachments or other integrations.
• Enterprise AI Architecture with Vector Database, Metadata, RAG, Dynamic Context Discovery (DCD), and Backup StrategyFeb 16, 2026. Build robust AI apps! This architecture uses Vector DB, RAG, DCD & metadata for accurate, scalable, and reliable responses. Includes backup strategy.
• 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!
• How to Create or Update a Lookup Column Using Web API in Power PagesJan 29, 2026. Learn how to create and update lookup columns in Power Pages using the Web API. This guide covers configuration, table permissions, and web role assignments for seamless integration.
• Understanding the LOOKUPVALUE DAX Function in Power BIJan 17, 2026. In this article, I demonstrated how to master the LOOKUPVALUE DAX function in Power BI W lean how to fetch values between tables without relationships, similar to VLOOKUP, and when to use it effectively.
• Understanding Filter rows and Expand Query in Dataverse (Power Automate)Dec 29, 2025. Unlock Dataverse power in Power Automate! Learn to efficiently filter and retrieve related data using Expand Query and Lookup Columns. Optimize flows and boost performance.
• Working With SharePoint Choice Columns in Power AppsDec 23, 2025. Master SharePoint choice columns in Power Apps! Learn to use Choices(), LookUp, Filter, and Patch with clear examples. Handle single & multi-select fields effectively.
• How to get lookup column records in Power Pages using Web APIDec 19, 2025. Learn how to retrieve data from Dataverse lookup columns in Power Pages using Web API and JavaScript. Access related records efficiently and securely with practical examples.
• How to Save Microsoft Forms Multi-Select Choices to a SharePoint Multi-Select Choice ColumnDec 12, 2025. Learn how to seamlessly transfer multi-select answers from Microsoft Forms to a SharePoint multi-select choice column using Power Automate. Streamline your data collection!
• How to Check if a SharePoint Rich Text Column Is Blank in Power AutomateDec 08, 2025. Struggling with blank SharePoint Rich Text columns in Power Automate? This guide provides a step-by-step solution to accurately identify and handle empty fields, ensuring reliable flow execution. Learn to convert HTML to text and trim unwanted content!
• Measures vs Columns in Power BI: Understanding the DifferenceDec 09, 2025. This articles explains what is measure and calculated column and difference between both in simplied manner.
• A Complete Guide to Auto-Fetching RSS Feed Images and Storing Them in a SharePoint Image Column Using Power AutomateDec 09, 2025.
• Entity Framework Core – A Complete and Deep ExplanationDec 06, 2025. This article provides a complete, descriptive, and beginner-to-advanced explanation of Entity Framework Core (EF Core). It covers how EF Core works internally, its core components, change tracking, relationship handling, migrations, DbContext, DbSet, performance features, advanced capabilities, concurrency handling, shadow properties, value conversions, global filters, interceptors, and when EF Core is suitable for real-world .NET applications. Written in a simple, clear style, this guide helps developers understand EF Core deeply without focusing on LINQ or specific approaches.
• How to Create or Update Multi-Select Person or Group Column in SharePoint Using Power AutomateDec 07, 2025. Learn how to create or update SharePoint multi-select Person or Group columns using Power Automate, including validating Office 365 users to skip invalid emails and ensure reliable, error-free flows execution.
• Building Dynamic Reordering Functionality in Power Apps Using Up/Down Arrow IconsDec 01, 2025. Effortlessly reorder items in your Power Apps Gallery with up/down arrow icons! This tutorial provides a simple, intuitive solution for dynamic record arrangement, improving user experience and control. Perfect for navigation menus, task prioritization, and more.
• Highly Customizable Reporting Architecture (Metadata → SQL → API → UI)Nov 21, 2025. Build a highly customizable reporting architecture using metadata. Empower users to create reports without code, ensuring security, scalability, and flexibility.
• Highly Customizable Reporting Architecture (Metadata → SQL → API → UI)Nov 21, 2025. Build flexible reporting systems using metadata! Automate SQL, API, and UI generation. Empower non-developers to create reports without coding. Scale reporting easily.
• Dynamic Row & Column Permission System (Field-Level Security Using a Rule Engine)Nov 19, 2025. Implement dynamic row and column-level security for enterprise apps. Centralize permissions, enforce rules at the API, and mask sensitive data. Enhance security and compliance.
• Dynamic Row & Column Permission System | Field-Level Security and Rule Engine for Angular + .NET ApplicationsNov 19, 2025. Implement dynamic row & column permissions in Angular & .NET apps. Secure sensitive data with field-level security, a rule engine, and metadata-driven access control.
• Building a Universal Data Import Wizard — mapping columns, preview, validationNov 18, 2025. Build a robust Angular data import wizard! Map columns, preview data, validate entries, and ensure secure, scalable imports. Includes code snippets & best practices.
• Fixing Special-Character Folder Names and Applying Default Metadata in SharePoint Online Using CSOMNov 19, 2025. Fix SharePoint Online folder metadata issues caused by special characters in folder names. This guide provides a PowerShell CSOM script to apply default metadata correctly.
• Creating a Metadata-Driven API Engine (API structure loaded from DB, no code changes)Nov 19, 2025. Build APIs without code changes! This guide shows how to create a metadata-driven API engine for faster iteration, centralized governance, and reduced maintenance.
• Dynamic Form Builder: Building Adaptive UI with Angular Reactive Forms and ASP.NET Core Metadata APINov 04, 2025. Build dynamic forms in Angular with ASP.NET Core! Use metadata to render forms at runtime, avoiding hardcoded HTML. Ideal for scalable enterprise apps.
• Understanding Reflection in C#Oct 29, 2025. Explore C# Reflection in ASP.NET WebForms! Dynamically inspect types, create objects, and invoke methods at runtime. Perfect for plugins and dynamic UIs.
• Unlocking Runtime Intelligence: A Formal Exploration of Reflection in .NETOct 18, 2025. Unlock the power of runtime intelligence with .NET Reflection! This article explores how to inspect and manipulate .NET code at runtime, covering key components like Assembly and Type inspection, dynamic member invocation, and custom attributes. Discover practical applications in dependency injection, ORMs, and testing, while learning best practices for performance and security. Explore alternatives like source generators for optimized metadata access.
• How to Construct a Toeplitz Matrix from a Given Row and Column in PythonOct 07, 2025. This article provides a comprehensive guide on constructing Toeplitz matrices from a given row and column, highlighting their significance in signal processing, particularly in wireless communication systems like 5G. Learn how to leverage SciPy for efficient implementation, explore real-world applications, and optimize performance for faster computations. Discover how this matrix structure bridges abstract algebra and practical engineering for high-speed, low-latency connections.
• How to Split Columns Easily in Fabric Dataflow Gen2Oct 01, 2025. Learn how to easily split columns in Microsoft Fabric Dataflow Gen2 to transform unstructured data into a structured format for better analysis. This guide covers splitting columns by delimiters like commas and semicolons, enabling you to parse skills, locations, or product codes. Streamline your data preparation workflows and unlock valuable insights in Power BI and Fabric Lakehouse with this powerful transformation technique. Master Dataflow Gen2 for efficient data reshaping!
• Choose a Data Storage Approach at the CloudAug 23, 2025. This Article explains different types of data classification—structured, semi-structured, and unstructured data—in simple, easy-to-understand language. It breaks down how each type is stored, organized, and used, with real-world examples like product catalogs, photos, and business reports. We also explored common data serialization formats (XML, JSON, YAML) with plain explanations, examples, pros and cons, and a comparison table. Finally, we summarized everything with a visual infographic and a comparison table to make it easy to remember.
• Advanced Document Set and Metadata-Driven Folder Management in SharePoint with PnPjsAug 19, 2025. Learn how to manage SharePoint documents using Document Sets, metadata-driven folders, and PnPjs in SPFx. Automate creation, enforce governance, and improve organization, compliance, and discoverability in enterprise libraries.
• Upload, Download, and Manage Files in SharePoint OnlineAug 18, 2025. Learn how to manage SharePoint files in SPFx using PnPjs: upload, download, update, delete files, handle version history, set metadata, and use chunked uploads for large files efficiently and securely.
• Folder Management in SharePoint Online with PnPjs and SPFxAug 18, 2025. Learn how to manage folders in SharePoint Online using PnPjs within SPFx. Explore folder creation, file upload, metadata updates, and governance best practices for efficient document library management.
• Fetch Column Headers from Excel Files in a Folder using Power AutomateAug 15, 2025. In this article its mainly focus on extracting the column header names from multiple excel sheet stored in a folder using Power Automate.
• Architecting Reusable Metadata (Site Columns) with Content Type HubAug 15, 2025. Even though I’ve worked with the Content Type Hub in several projects, I often found it confusing to set up and wasn’t always sure which best practices to follow. This time, I’ve been given a unique requirement that lets me combine what I’ve learned before with a fresh point of view. It finally feels like the right time to share my experience based on real, hands-on work.
• How document's metadata/property sync behaves - SPO To MS Office Files (Word, Excel, PPT) and MS Office Files Aug 16, 2025. Learn how document metadata and property synchronization works between SharePoint Online (SPO) and Microsoft Office files like Word, Excel, and PowerPoint. Understand sync behavior, limitations, and best practices for managing file properties across platforms.
• Dataverse Gets Smarter! Introducing Prompt Columns in Power PlatformAug 07, 2025. If you're working with Microsoft Power Platform, especially Dataverse, here’s a cool update you should know about – a new column type called "Prompt" is now available (in preview as of writing this post).
• Create SharePoint Lists and Columns in SPFx Using PnPjsAug 04, 2025. Learn how to use PnPjs (spfi) in SPFx to dynamically create various SharePoint list columns like text, number, date, choice, and lookup fields using addFieldAsXml for seamless customization and automation.
• Evolution of Database SystemsJul 31, 2025. This article traces the evolution of databases from flat files to AI-driven metadata systems, highlighting how intelligent architectures are transforming data discoverability, governance, and operational efficiency in modern platforms.
• Creating a Semantic Model in Microsoft Fabric WarehouseJul 15, 2025. Transform raw warehouse tables into business-friendly insights using semantic models in Microsoft Fabric Warehouse. Enable self-service analytics, Power BI integration, and centralized data modeling with ease.
• How to Use PnPjs in SPFx to Query SharePoint List ColumnsJul 11, 2025. Learn how to configure PnPjs in your SharePoint Framework (SPFx) project and query all common SharePoint column types including Lookup, Person, Choice, and more.
• Hide Column Headers and Show Row Headers in C#Jul 08, 2025. Learn how to display DataGridView data horizontally in a WinForms application. This article shows you how to set up row headers, add columns, and rotate data display programmatically.
• Migrate SharePoint On-Premise Data to Online via ShareGateJun 30, 2025. Learn how to migrate data from SharePoint 2019 to SharePoint Online using ShareGate. This guide covers prerequisites, step-by-step migration, authentication, metadata handling, and best practices for success.
• 🔍 Efficient Ways to Organize Your SharePoint Document LibrariesJun 09, 2025. A well-structured SharePoint document library is essential for productivity and ease of access. Whether you're starting from scratch or planning a clean-up, here are four smart organizational methods to manage your files better—and when to apply each.
• How Indexed Columns Improve SharePoint List SpeedJun 04, 2025. Indexed columns in SharePoint help improve list and library performance by allowing faster filtering and searching, especially in large lists with thousands of items.
• How to Use the Sort Function in Power Apps with Dynamic Column Values from a SharePoint ListMar 22, 2025. This article covers features, advantages, disadvantages, and step-by-step instructions to enhance your data management and user experience.
• Efficiently Splitting SharePoint Column Values Using Power Apps Split FunctionMar 20, 2025. This article explores how to use the Split function in Power Apps to dynamically extract and display the first and last names from a full name stored in a SharePoint list's people picker column.
• How to Update a Managed Metadata Field Value in SPFxFeb 19, 2025. Updating a Managed Metadata field in SharePoint Framework (SPFx) with the latest version of PnP.js (SPFI) is straightforward once you understand the basics.
• Reduce NULL Storage in SQL Server with Sparse ColumnsFeb 05, 2025. SQL Server Sparse Columns optimize storage by not allocating space for NULL values, improving efficiency. They support filtered indexes and column sets for dynamic queries but add a 4-byte overhead for non-NULL values, requiring careful use.
• How to Concatenate Dynamic Column Values in Power AppsJan 23, 2025. Learn to use the Concatenate function in Power Apps to combine dynamic column values in a gallery. Simplify data presentation, reduce redundancy, and enhance user experience with this versatile tool for custom business applications.
• Add Data Bars UI in SharePoint List Column Formatting in SharePoint ListJan 01, 2025. This article walks you through the process of customizing your SharePoint list columns for better data visualization and enhancing the current view with conditional formatting to display dynamic, visually appealing data bars.
• Using Derived Column Task in SQL Server Integration ServicesDec 30, 2024. The Derived Column Task in SQL Server Integration Services (SSIS) allows you to transform or modify data within your ETL process. It enables the creation of new columns or updates to existing ones using SSIS expressions.
• SharePoint Online - Add/Update Taxonomy Field Using Graph API Oct 25, 2024. This guide covers step-by-step instructions for integrating taxonomy fields, managing metadata, and customizing fields in SharePoint lists and document libraries. Enhance your SharePoint solutions with precise metadata control.
• Dependency Properties in WPF: Benefits, Usage, and Examples in C#Oct 21, 2024. A Dependency Property in WPF is a specialized property supported by the WPF property system. It enables data binding, styling, animation, and value inheritance. This system improves memory efficiency and provides automatic change notifications, making it essential for dynamic, data-driven applications.
• Using Attributes and Metadata in C# 12Oct 20, 2024. Ziggy Rafiq demonstrates how to use attributes and metadata in C# 12 including improvements in parameter types, reflection capabilities, and best practices for maintaining self-documenting code.
• Understanding List Column Data Types in SharePoint Oct 15, 2024. SharePoint allows users to create and manage lists with various column types, such as text, number, date, and lookup fields. These columns help organize and store data effectively, ensuring better reporting and data integrity.
• A Detailed Explanation of COUNT in SQL ServerOct 01, 2024. This article explores the differences between SQL counting methods: COUNT(*), COUNT(1), COUNT(column_name), and COUNT(DISTINCT column_name). It highlights their purposes, performance considerations, and use cases, emphasizing the importance of choosing the right COUNT function for efficient queries.
• Database Dictionary (1-1) --- Server, Database, Schema, Table and ColumnSep 24, 2024. This article is to discuss the major schemata in SQL server.
• Dynamic SharePoint Column Creator with jQuerySep 24, 2024. Unlock the power of SharePoint with our Dynamic SharePoint Column Creator using jQuery! This innovative tool allows users to effortlessly create and customize columns in SharePoint lists.
• Trigger Approval flow with SharePoint Column FormattingSep 21, 2024. To trigger a workflow with a button using column formatting in SharePoint, you can create a column that uses JSON formatting to display a button that, when clicked, initiates a workflow.
• How to Keep SQL Server Table Columns in SyncSep 19, 2024. how to keep columns in sync across SQL Server tables using efficient methods like triggers, SQL scripts, and the MERGE statement.
• Update Taxonomy Metadata Field with Multiple Values Using Logic AppSep 19, 2024. This guide covers automating metadata management, configuring Logic Apps to handle dynamic updates, and simplifying the process of managing SharePoint Taxonomy Metadata fields efficiently.
• Site Column & List Column and Site Content TypeSep 03, 2024. This article covers SharePoint's Site Columns, List Columns, and Site Content Types. It explains the differences between Site and List Columns, including their scope, reusability, and management.
• Managed Metadata In SharePointAug 13, 2024. This article is about Managed Metadata in SharePoint. Managed Metadata in SharePoint centralizes term management across sites, enhancing content organization and consistency. It improves search accuracy, prevents data mismatches, and supports efficient content tagging through taxonomy and term sets.
• jQuery DataTable Plugin to Customize Tables in Power Pages PortalJul 19, 2024. How to integrate the jQuery DataTable Plugin into custom tables within the Power Pages Portal. The DataTable Plugin enhances tables by providing features such as pagination, column filtering, efficient search capabilities, and customizable styling.
• Dynamically Creating a Table in SQL Server from Information SchemaJul 19, 2024. This SQL script dynamically creates a table in SQL Server by utilizing INFORMATION_SCHEMA and system views. It constructs the table definition, including columns, data types, constraints, and default values.
• Understanding @wraps in Python: Preserving Function MetadataJul 07, 2024. Explore the intricacies of Python's @wraps decorator, essential for preserving function metadata. Learn how @wraps simplifies debugging, maintains docstrings, and ensures correct function signatures, enhancing clarity and reliability in your Python codebase.
• How to Seed Identity in SQL ServerJul 03, 2024. Discover SQL Server's IDENTITY columns for automatic unique number generation. Learn to create tables with IDENTITY, insert data without specifying IDs, seed values with DBCC CHECKIDENT, manage explicit ID insertions with IDENTITY_INSERT, and reset identity seeds using TRUNCATE TABLE.
• Working with Choices Columns in Dataverse using Power AutomateJul 03, 2024. Over the past few months, I've led a project using the Power Platform, achieving remarkable results. Today, I will share tips on working with Choices Columns in the Dataverse. Unlike SharePoint, Dataverse assigns unique IDs to each choice, requiring specific handling in Power Automate and PowerApps,
• Create Different Values in Same Dropdown Control in PowerAppsJul 03, 2024. Learn to customize dropdown values in PowerApps based on form requirements. Explore methods for different forms requestor and approver using single-line text or choice columns. Ensure data integrity and usability with dynamic dropdowns tailored to user roles and project phases.
• Query to find Table Name, Row Count, Column Count and Data SizeJul 02, 2024. This guide covers techniques to query and display table names, row counts, column counts, and data sizes efficiently. Ideal for database administrators and developers seeking to optimize data management and performance analysis.
• Dataverse Multi Choice Columns in PowerAppsJul 02, 2024. Discover how to efficiently work with PowerApps and Dataverse, specifically focusing on handling Multi Choice Columns. Learn how to use the Concat function to display multi-choice values in a label within a vertical gallery. Enhance your PowerApps skills with this practical guide!
• Understanding the PowerApps GroupBy FunctionJul 02, 2024. Learn about PowerApps' GroupBy function syntax and limitations. It's effective for grouping text, number, date, and duration columns but doesn't support Choices and Lookup columns. Essential for efficient data organization in PowerApps applications.
• Updating Lookup Columns in Dataverse with Power AutomateJul 02, 2024. Navigating Lookup Columns in Dataverse using Power Automate requires precise handling. Unlike simpler data sources, such as SharePoint, updating these columns demands using a specific format like "Contacts(83c259e2-1039-4110-af70-79f353dc92a5)".
• How to Remove Extra Column from DataGrid WPF ControlMay 31, 2024. The WPF DataGrid often displays an extra column due to default behavior. This issue arises when the source data contains fewer columns than displayed. By adjusting the XAML code and setting the ColumnWidth attribute to "*", the extra column can be removed, ensuring proper alignment of data in the DataGrid.
• Understanding Reflection in C# May 28, 2024. Reflection in C# allows runtime inspection and interaction with object types and members, enabling dynamic invocation, type inspection, and metadata access. It's powerful for development tools and debugging utilities.
• Enhance Your Blazor QuickGrid with Dynamic with Button on ColumnsMay 16, 2024. Learn how to enhance your Blazor QuickGrid by adding dynamic buttons to columns. This tutorial explores integrating interactive buttons within column cells, offering users tailored actions and improved functionality.
• Column Values Reverse Order in SQLMay 08, 2024. Learn how to reverse the order of column values in SQL using the ORDER BY clause with the DESC keyword. This tutorial covers sorting data in descending order, manipulating column values, and enhancing database management skills.
• How to Create Calculated Column in SharePoint OnlineMar 22, 2024. SharePoint Online offers robust tools for collaboration and data organization. Learn how to update calculated column formulas to adapt to evolving business needs seamlessly. Follow a step-by-step guide to configure formulas, ensuring accurate data and enhancing analysis capabilities.
• React Apexcharts: Create & Download Column Bar Chart with BootstrapMar 16, 2024. In this tutorial, we will learn how to create a vertical column bar chart component in the React JS functional component. Creating a Column Bar Chart component in React using Apexcharts and Bootstrap. Configure data and options for visualization.
• How Indexing Columns works in SharePoint Online?Mar 11, 2024. This article illustrates the process of creating an index column within SharePoint Online List/Library to enhance the efficiency of querying and retrieving results from SharePoint Online List/Library.
• Understanding the .NET Internal Compile ProcessMar 11, 2024. In this article, we will learn about CLR, Jit Compiler, and how the .NET compilation process works. Understanding the .NET internal compile process involves dissecting how source code is translated into executable binaries.
• 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.
• Understanding Grouping by Columns in SharePoint ListsMar 04, 2024. In this article, we will discover how to efficiently organize and manage data in SharePoint Lists by understanding the powerful grouping capabilities.
• Calculated Columns vs. Measures in Power BIFeb 29, 2024. In this article, calculated columns and measures are crucial in Power BI for robust data analysis. Calculated columns, akin to spreadsheet columns, are static and impact data refresh performance. Measures, dynamic calculations, enhance report efficiency, adapting to context changes.
• 2D Array with Matrix Multiplication in C ProgrammingFeb 28, 2024. A double subscripted variable, also known as a two-dimensional array, is a variable that has two subscripts assigned to it in order to represent a list of items.
• Power Automate Flow to Update Sharepoint Column ValueFeb 27, 2024. In this article, I will be explaining how you can update the old value to the new value in the SharePoint list column using power automate flow.
• Clustered Column Chart in Power BIFeb 23, 2024. A clustered column chart in Power BI will allow easy customization and formatting. Users can adjust the colors, labels, and axes to better suit their needs and preferences.
• Date and Time Column Behavior in SharePoint List/LibraryFeb 12, 2024. In this article, we will learn how managing date and time column conversions in applications becomes challenging when your organization spans multiple offices across different time zones.