Relationships Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/relationships/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 20:21:29 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Relationships Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/relationships/ 32 32 How to Properly Handle Dates in Excel Pivot Tables https://www.xelplus.com/pivottable-dates-grouping/ Thu, 19 May 2022 08:00:00 +0000 https://www.xelplus.com/?p=9286 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 Properly Handle Dates in Excel Pivot Tables appeared first on Xelplus - Leila Gharani.

]]> How to Do Many-to-One Side Calculations in Data Models with DAX https://www.xelplus.com/dax-many-to-one-side-calculations/ Thu, 10 Mar 2022 10:00:00 +0000 https://www.xelplus.com/?p=9406 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 https://www.xelplus.com/create-pivot-table-from-multiple-sheets/ Thu, 01 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9978 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 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.

]]> Excel vs. Google Sheets – Is Excel Better? https://www.xelplus.com/excel-vs-google-sheets/ Thu, 01 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10646 These are 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

The post Excel vs. Google Sheets – Is Excel Better? appeared first on Xelplus - Leila Gharani.

]]>