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