Relationships Archives - Xelplus - Leila Gharani

How to Group Dates in Excel Pivot Tables

Leila Gharani — Thu, 19 May 2022 08:00:00 +0000

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

The post How to Group Dates in Excel Pivot Tables appeared first on Xelplus - Leila Gharani.

How to Do Many-to-One Side Calculations in Data Models with DAX

Leila Gharani — Thu, 10 Mar 2022 10:00:00 +0000

In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.

The post How to Do Many-to-One Side Calculations in Data Models with DAX appeared first on Xelplus - Leila Gharani.

How to Create a Pivot Table from Multiple Sheets in Excel

Leila Gharani — Thu, 01 Jul 2021 08:00:00 +0000

Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.

The post How to Create a Pivot Table from Multiple Sheets in Excel appeared first on Xelplus - Leila Gharani.

How to Create a Pivot Table Based on Multiple Sheets and Tables

Leila Gharani — Thu, 29 Oct 2020 17:18:00 +0000

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.