Tag: Excel

Chi-Square Test In Excel: Comparing Variables

Chi-Square Test In Excel: Comparing Variables - Enterprise DNA

In this post, we’re going to show you how to use the Chi-square test in Excel to compare variables. You can watch the full video of this tutorial at the bottom of this blog. The Chi-square test of independence has two categorical variables. We will find out if there’s any relationship between those variables. We

Continue reading

Excel Hacks Every Business Should Know

Excel Hacks Every Business Should Know - Enterprise DNA

No matter what industry you belong to, having a better understanding of Microsoft Excel gives you a huge advantage. Especially if you have a few Excel hacks up your sleeve, you can deal with your data in a more efficient manner. Here are a few simple hacks that could help you breeze through some of

Continue reading

Format Currencies In Power BI Using DAX

This tutorial will focus on currency conversions and how to format these converted currencies using DAX in Power BI. You may watch the full video of this tutorial at the bottom of this blog. In this example, Sales will be used to run a report based on different currencies from World Wide Importer’s data. Assumptions

Continue reading

Create A Lookup Table From Subtotals: Optimization In Power BI

In this tutorial, we’ll go through a technique that will create a lookup table from subtotals using the query editor in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is most useful when we’re getting data out of Microsoft Excel because most of its data

Continue reading

How To Create Unique Subtotals In Power BI Tables

How To Create Unique Subtotals In Power BI Tables

In this tutorial, I’m going to show you how to create unique subtotals in your Power BI tables using the SWITCH TRUE logic. You may watch the full video of this tutorial at the bottom of this blog. This is a breakout session from a financial reporting course released by Enterprise DNA. The session includes

Continue reading