Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to add the text numbers at the end of a description to get a Sales Total using Power Query User Interface. This trick comes from YouTuber Excel Teammates Peets and Software Train.
Another new LAMBDA helper function in Excel is MAKEARRAY. This video shows a simple example, and then tackles the problem from episode 2317 of how to unwind a rectangular range into a single column so you can pass it to Continue reading “UNIQUE of Rectangular Range Using MAKEARRAY in Excel – 2416”
Three more of the new Lambda Helper functions in Excel: MAP, REDUCE, and SCAN. In today’s episode, see three different ways to create a PRODUCTIF function in Excel using MAP, REDUCE, or SCAN.
Important points:
MAP can take one or more arrays.
MAP Continue reading “PRODUCTIF With MAP REDUCE or SCAN – 2416”
A first look at the new Excel functions BYROL and BYCOL. These functions, released to Insiders Fast this week are designed to be used with LAMBDA functions.
Read more about the 7 functions here:
https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-helper-functions-lambdas-as-arguments-and-more/bc-p/2587253#M2240
Microsoft is releasing a new look for the Excel Quick Access Toolbar and Ribbon. The feature is rolling out slowly to beta Insiders now. Here is a first look at the QAT and Ribbon.
A question from Quora: Can you sort one column in an Excel table using the Filters and not sort the other columns? This would be easy if it was a range. But it you press Ctrl+T, I am not sure Continue reading “Sort One Column Challenge In Excel – 2413”
Good Monday everyone!
In today’s video, I will answer Google most asked questions on Power Query. Enjoy!
Chapters:
00:00 Intro
00:16 Is power query free?
01:00 Is power query available in Excel 2010?
01:30 Is power query available for mac?
01:50 Is power query an ETL tool?
02:20 Continue reading “Is Power Query…..? | Google’s most asked questions on Power Query”
For today’s video, I’d like to show how you can use and maximize Canva in creating custom Power BI themes. Canva is a graphic design and publishing platform that allows you to create visual artworks, presentations, and documents with easy-to-use tools Continue reading “Creating Power BI Themes in Canva”
Continuing on our promise to provide new courses every month, we’ll be releasing one of our highly anticipated courses of the year – the first installment of Power Query/M Masterclass developed by our in-house Power Query expert, Melissa de Korte. Join Melissa, Continue reading “Intro To Power Query/M Masterclass – Brand New Course”
For today’s video, I want to show you different ways how you can get a hold of demo data to practice running analysis and apply techniques that you’re learning from our channel and also through our education platform. You’d want Continue reading “Where To Get Demo Data For Example Reports And Power BI Applications”
EVENT DETAILS – https://enterprisedna.co/enterprise-dna-community-event/
When is it?
June 28th, 5pm New York (EDT), 2pm Los Angeles (PDT), 10pm London (BST)
June 29th, 7am Sydney (AEDT), 9am Auckland (NZDT)
How long is it?
Session will run for 60 mins
Where is it?
Join in from Continue reading “eDNA Community Event (Member-Only)”
Download Excel Files: https://excelisfun.net/files/EMT1725-1726Start.xlsx Download Solution: https://excelisfun.net/files/EMT1725-1726Finished.xlsx
Learn how to calculate Moving Annual Total with DAX using the CALCULATE, SUM, LASTDATE and DATESINPERIOD functions.
Topics:
1. (00:00) Introduction
2. (00:25) Show Data Model
3. (00:48) Build Initial Data Model Continue reading “Moving Annual Total with DAX Measure. Excel Magic Trick 1726.”