Power Pivot Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/power-pivot/ Bestselling Excel and Power BI Courses Thu, 25 Jul 2024 15:49:39 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Power Pivot Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/power-pivot/ 32 32 DAX CALCULATE Function Made Easy to Understand https://www.xelplus.com/dax-calculate-function/ Thu, 09 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=1491 If you'd like to "see" how the DAX CALCULATE function works, then you need this tutorial. It will show you how the CALCULATE function works and delivers results.

The post DAX CALCULATE Function Made Easy to Understand appeared first on Xelplus - Leila Gharani.

]]> Hidden Tips for Excel Data Model and Power Pivot https://www.xelplus.com/3-hidden-tips-for-power-pivot/ Tue, 30 Nov 2021 08:17:00 +0000 https://www.xelplus.com/?p=9707 These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.

The post Hidden Tips for Excel Data Model and Power Pivot appeared first on Xelplus - Leila Gharani.

]]> How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick https://www.xelplus.com/excel-interactive-dashboard-trick-dax/ Thu, 09 Sep 2021 08:43:00 +0000 https://www.xelplus.com/?p=9812 With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

The post How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick appeared first on Xelplus - Leila Gharani.

]]> Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) https://www.xelplus.com/excel-switch-columns-multiple-values/ Thu, 29 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9917 Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

]]> How to Create a Pivot Table Based on Multiple Sheets and Tables https://www.xelplus.com/relationships-pivot-tables-multiple-sheets/ Thu, 29 Oct 2020 17:18:00 +0000 https://www.xelplus.com/?p=10572 This is a simple but advanced Pivot Table technique in Excel. If you'd like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.

The post How to Create a Pivot Table Based on Multiple Sheets and Tables appeared first on Xelplus - Leila Gharani.

]]>