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
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)”
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!”
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.”
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.”
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”
Salama from YouTube has two columns of numbers. The area in column A is from 1 to 36. The month in column B is from 1 to 12. How many times does each combination of Area and Month happen?
Today’s video Continue reading “Excel Frequency Of Combination Of Two Columns – 2420”
Ten really short Excel topics jammed into one 188-second video.
Cube Functions spill – article by Chris Webb is at https://blog.crossjoin.co.uk/2021/07/28/excel-cube-functions-dynamic-arrays-and-lambdas-part-1-getting-all-the-items-from-a-set/
Read more about the new Power Query book at https://www.mrexcel.com/products/master-your-data-with-power-query-in-excel-and-power-bi/
Table of Contents
(0:00:00) Welcome
(0:00:12) #1 Continue reading “Excel Quick Takes Ten Excel Topics In 3 Minutes – 2419”