Data Model Archives - Xelplus - Leila Gharani

How to Properly Handle 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 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

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 Use Power BI – Beginner’s Guide

Leila Gharani — Thu, 16 Dec 2021 10:00:00 +0000

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you'll have setup your interactive dashboard which you've published to the web!

The post How to Use Power BI – Beginner’s Guide appeared first on Xelplus - Leila Gharani.

DAX CALCULATE Function Made Easy to Understand

Leila Gharani — Thu, 09 Dec 2021 10:00:00 +0000

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.

3 Hidden Tips for Excel Power Pivot

Leila Gharani — Tue, 30 Nov 2021 08:17:00 +0000

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 3 Hidden Tips for Excel Power Pivot appeared first on Xelplus - Leila Gharani.

How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick

Leila Gharani — Thu, 09 Sep 2021 08:43:00 +0000

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)

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

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 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.

Excel vs. Google Sheets – Is Excel Better?

Leila Gharani — Thu, 01 Oct 2020 09:00:00 +0000

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.