DAX Archives - PK: An Excel Expert

How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI

January 30, 2023October 10, 2026 PKComments Off

Introduction Have you ever tried to write a complex Excel function, VBA code, or DAX using natural language? It can be challenging and time-consuming. If this is your situation, then

Power BI

Power BI dashboard with 3D Glass Chart

January 23, 2023October 10, 2026 PKComments Off

Data visualization is an important part of modern businesses. It helps companies to make decisions based on data-driven insights. Microsoft Power BI is a business intelligence tool Which provides the

Power Pivot Excel Tips and Tricks

Data Transformation to Create Comma Separated List Automatically

December 12, 2022October 10, 2026 PKComments Off

Data transformation is an important aspect of data analysis and is often used to manipulate data in a way that suits our needs. One such manipulation is to Create Comma

Power Pivot

Profit Analysis Dashboard using What-if Parameter

April 27, 2022March 4, 2025 PKComments Off

In this article, we have created a Profit Analysis using What-if Parameter in Microsoft Power BI. You can use this trick in your Sales dashboard. Profit Analysis Dashboard using What-if

Power BI

Static and Dynamic Row-Level Security in Power BI

October 25, 2020October 10, 2026 PKComments Off

Row-level security in Power BI uses role filters to restrict which data rows users can access. This tutorial introduces static and dynamic approaches, including the USERPRINCIPALNAME DAX function for the

Power BI

Comparative Analysis Dashboard in Power BI

September 6, 2020September 19, 2026 PKComments Off

The Comparative Analysis Dashboard in Power BI compares current-year sales with previous-year sales and budget. It shows year-over-year growth, budget variance, category and product analysis, and monthly trends. The example

Power Pivot

Power Pivot KPIs in Excel: Create, Edit and Delete

January 15, 2020September 19, 2026 PKComments Off

A Power Pivot KPI compares a base measure with a target and displays a status using defined thresholds. This Excel tutorial shows how to create, display, edit and delete a

Power Pivot

SUMX Function in Power Pivot: Revenue Measure with RELATED

January 13, 2020October 9, 2026 PKComments Off

The SUMX function in Power Pivot lets you calculate revenue with a single measure, without adding any helper columns to your data. In this tutorial you load an Orders table

Power Pivot

Calculated Column in Power Pivot: LOOKUPVALUE vs RELATED

January 9, 2020October 9, 2026 PKComments Off

A calculated column in Power Pivot adds a new field to a data model table, computed row by row with a DAX formula. In this tutorial you have an Orders

Tag: DAX

How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI

Power BI dashboard with 3D Glass Chart

Data Transformation to Create Comma Separated List Automatically

Profit Analysis Dashboard using What-if Parameter

Static and Dynamic Row-Level Security in Power BI

Quality Analysis Dashboard in Power BI

Comparative Analysis Dashboard in Power BI

Power Pivot KPIs in Excel: Create, Edit and Delete

SUMX Function in Power Pivot: Revenue Measure with RELATED

Calculated Column in Power Pivot: LOOKUPVALUE vs RELATED