For the 4th and final installment to our year-end course countdown, weāre pleased to announce that weāll be releasing our Applied Problem Solving with Power Query/M course thatās developed and instructed by Enterprise DNA Expert, Melissa de Korte.
For those of Continue reading “Learn Applied Problem Solving With Power Query / M – New Course”
In this tutorial, Antriksh is going to demonstrate how you can tackle a DAX problem in order to identify Top 3 dates and its respective financial level by using a complex logic.
***** Video Details *****
00:00 Introduction
01:46 Data model
02:28 Measure V1
11:54 Continue reading “Reverse TOPN Based On Dates Selected In Slicer”
Tina C asks if there is a better way to add a page break every 35 rows. Way back in episode 360, I showed a few methods. But today, one line of VBA in the Immediate Window seems much easier. Continue reading “Excel Page Break by Rows with VBA”
Evil Angel on YouTube asks if you can do a VLOOKUP in a Pivot Table Calculated Field. I am fairly sure this won’t work in a regular pivot table based on the pivot table cache. But if you build a Continue reading “Excel VLOOKUP In Pivot Table Calculated Field? – 2456”
In line with our recently released courses on Microsoft SharePoint, Enterprise DNA Expert, Henry Habib, talks about the 3 key benefits that you can achieve from using SharePoint.
Check out our SharePoint courses here:
https://portal.enterprisedna.co/courses/enrolled/1602889
https://portal.enterprisedna.co/courses/enrolled/1602908
***** Continue reading “Benefits Of Using SharePoint In Your Power BI Report Development”
Download Excel File: https://excelisfun.net/files/EMT1769.xlsx
Learn Accounting and Financial Spilled Array Formulas when the formula uses a Relative Cell Reference, One Cell Above, as an Accumulator like in investment value from period to period (multiplicative) or a checkbook balance Continue reading “SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769”
Please watch the video for a step by step walkthrough and explanation of the how to in this tutorial.
In this video, weāre going back to basics and Iāll show you the fastest way to create a highly comprehensive data table within the Power BI Models from scratch.
Iāve done so many tutorials about creating date tables over the years, Continue reading “The Fastest Way To Create A Comprehensive Date Table Within Your Power BI Models”
Download Excel File: https://excelisfun.net/files/EMT1768.xlsx
Happy Holidays, Online Excel Team!!!!!! –excelisfun
Song Credits:
Jingle Bells 7 by Kevin MacLeod is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/
Artist: http://incompetech.com/
As the 3rd installment to our year-end weekly course release and our 15th course this year, weāre excited to announce that weāre rolling out our very first course on Report Development Best Practices, developed and instructed by Enterprise DNA Expert, Continue reading “Refining Your Power BI Skills With This Report Development Best Practices Checklist – New Course”
Today a question from someone who frequently uses three currency styles in Excel: USD, EGP, and SAR. Excel makes it easy to choose USD, GBP, EUR, CHF but if your currency is not in that drop-down, then you are scrolling Continue reading “Excel Easily Choose Which Currency – 2455”
My courses on Retrieve: https://mrexcel.retrieve.com/store/#/
For a special holiday-week treat, change the color of the gridlines in Excel to red. It could drive your co-workers insane.
Actually, as time goes by, the gridlines are becoming more faint. Changing the Continue reading “Red Gridlines In Excel – 2454”
This video will be the start of a new periodic series that Iād like to call āPower BI Buried Treasuresā. I thought itād be interesting to find a way to highlight functions and operators in Power BI that you may Continue reading “Power BI Buried Treasures: Modulo and Integer-Divide”