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”
Month: August 2021
Is Power Query…..? | Google’s most asked questions on Power Query
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”
eDNA Community Event (Member-Only)
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)”
Where To Get Demo Data For Example Reports And Power BI Applications
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”
Intro To Power Query/M Masterclass – Brand New Course
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”
Creating Power BI Themes in Canva
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”
Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725
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 using Power Query. See multiple user Interface Steps and a Custom M Code Function.
Learn how to calculate Moving Annual Total in Continue reading “Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725”
Moving Annual Total with DAX Measure. Excel Magic Trick 1726.
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.”
Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
Download Excel File: https://excelisfun.net/files/EMT1727.xlsx
See three formulas to lookup nth value:
1. (00:00) Introduction
2. (00:32) Formula #1: Microsoft 365 with INDEX and FILTER functions.
3. (01:31) Formula #2: Excel 2010 or later: AGGREGATE, ROW and INDEX functions.
4. (03:47) Ctrl + Continue reading “Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.”
Old Guy BMX Park & Racing in Same Day = Rad!
Excelisfun, aka Magic / Gel, gets rad with the Old Guys: BMX racing and BMX Park in the same day.
Peninsula Indoor BMX Track and Port Orchard Skate-BMX park hit in the same day in Port Orchard, WA. Old Guys Mike Continue reading “Old Guy BMX Park & Racing in Same Day = Rad!”
Excel Lambda Now Supports Optional Arguments And ISOMITTED – 2417
You can build Lambda functions in Excel that support optional arguments. A new ISOMITTED function lets you check if the argument was supplied or not.
Excel Navigation Pane Debuts – 2418
A new navigation pane debuts in Excel. It is a feature for people with low vision who are using Excel with a screen reader. Take a look at how you can easily make your workbook easier to navigate.