DAX Archives - PK: An Excel Expert

Excel Tips and Tricks

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

January 30, 2023January 30, 2023 PKComments Off

3D Glass Chart in Power BI

Power BI

Power BI dashboard with 3D Glass Chart

January 23, 2023January 23, 2023 PKComments Off

Data Transformation to create Comma Separated List automatically

Excel Tips and Tricks Power Pivot

Data Transformation to create Comma Separated List automatically

December 12, 2022December 12, 2022 PKComments Off

Profit Analysis using What if Analysis

Power Pivot

Profit Analysis Dashboard using What-if Parameter

April 27, 2022May 10, 2022 PKComments Off

Row Level Security in Power BI

Power BI

Static and Dynamic Row Level Security in Power BI

October 25, 2020October 25, 2020 PKComments Off

KPI in Power Pivot

Power Pivot

KPI in Power Pivot for dashboard and report

January 15, 2020January 15, 2020 PKComments Off

SUMX Function

Power Pivot

SUMX Function in Power Pivot

January 13, 2020January 13, 2020 PKComments Off

Power Pivot

Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)

January 9, 2020January 9, 2020 PKComments Off