DAX Archives

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

January 30, 2023January 30, 2023 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, 2023March 5, 2023 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

Data Transformation to create Comma Separated List automatically

Excel Tips and Tricks Power Pivot

Automatically Creating Employee-wise Skill Set Lists

December 12, 2022March 8, 2023 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 creating comma-separated lists

Power Pivot

Profit Analysis Dashboard using What-if Parameter

April 27, 2022May 10, 2022 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. [caption id="attachment_57629" align="alignnone" width="1920"]

Power BI

Static and Dynamic Row Level Security in Power BI

October 25, 2020October 25, 2020 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 Pivot

KPI in Power Pivot for dashboard and report

January 15, 2020January 15, 2020 PKComments Off

Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of

Power Pivot

SUMX Function in Power Pivot

January 13, 2020January 13, 2020 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, 2020January 9, 2020 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

Automatically Creating Employee-wise Skill Set Lists

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)