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 9, 2024 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, 2023July 14, 2024 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, 2022August 7, 2024 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, 2020August 27, 2024 PKComments Off

Row level security with Power BI is used to restrict data access for particular users. Filters restrict data access at the row level, which are defined within roles in Power

Power BI

Comparative Analysis Dashboard in Power BI

September 6, 2020February 18, 2025 PKComments Off

Introduction Comparative Analysis is very important for each business. Using these analysis they can see the insights how they are performing over a period of time. And, which product, service

Power Pivot

KPI in Power Pivot for dashboard and report

January 15, 2020October 7, 2024 PKComments Off

Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI in Power Pivot for dashboard is designed to help users quickly evaluate the

Power Pivot

SUMX Function in Power Pivot

January 13, 2020October 6, 2024 PKComments Off

In this article, we have explained how to use Measure in Pivot Pivot data model. We have taken the example of SUMX function to calculate the revenue. On the base

Power Pivot

Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)

January 9, 2020October 6, 2024 PKComments Off

In this article, we have explained how to use calculated column in Power Pivot Data Model. We have taken the example of Orders data wherein we have product level Unit

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

KPI in Power Pivot for dashboard and report

SUMX Function in Power Pivot

Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)