Tag: Excel Magic Trick

Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total

Read MoreView 8 Comments

Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report

Read MoreView 11 Comments

Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables

Welcome to Excel Magic Trick number 1,407. Hey, if you want to download this Excel workbook Excel Magic Trick 1,407 finished file or the start file so you can follow along, click on the link below the video. Hey, back in Excel Magic Trick 1,405, we saw how to create a monthly revenue and add…

Read MoreView 11 Comments

Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total

Welcome to Excel Magic Trick number 1394. If you want to download this Excel workbook, Excel Magic Trick 1393-94 so you could follow along, click on the link below the video. Wow, we have a crazy video here. We’ve got to calculate formulas for traditional pivot table calculations, such as percentage of column total, percent…

Read MoreView 14 Comments

Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns

Welcome to Excel Magic Trick number 1,420. Hey, if you want to download this Excel workbook, the start file or the finished file so you can follow along, click on the link below the video. Ranking in Power Query? Is it possible? Well, I actually searched all over to try to find a ranking function…

Read MoreView 17 Comments

Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer

Welcome to Excel Magic Trick number 1418. Hey, if you want to download this Excel workbook so you could follow along, click on the link below the video. Hey, last video, we saw how to rank for unit profit and total profit, either for products or products within manufacturer. But in the last video, we…

Read MoreView 15 Comments

Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop

Welcome to Excel magic trick number 1,443. Hey, if you want to download this Excel workbook, either the start file or finished file so you could follow along, click on the link below the video. Hey, we’ve got to see how to create a DAX formula for calculating sales per working day. And of course,…

Read MoreView 22 Comments

Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)

Welcome to Excel magic trick number 1,408. Hey, if you want to download this Excel workbook, Excel magic 1,408 start file or the finished file, so you can follow along, click on the link below the video. Hey, back at Excel magic trick 1,406, we were trying to calculate a moving 12 month average. Here’s…

Read MoreView 20 Comments

Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?

Welcome to Excel Magic Trick number 1,378. Hey, if you want to download this Excel workbook– Excel Magic Trick 1,378 Start– or the finished file so you can follow along, click on the link below the video. Hey, we’ve got a great video here. We’ve got to calculate the average of customer total sales by…

Read MoreComment

Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!!

Welcome to Excel Magic Trick number 1,429. Hey, if you want to download this Excel workbook, either the Start file or Finish file so you can follow along, click on the link below the video. Hey, back in Excel Magic Trick 1,420, we saw how to use Power Query to rank. Back in Excel Magic…

Read MoreView 9 Comments