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”
A column of currency ended up with commas for both the thousands separator and the decimal point! How can you replace the last comma
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”
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.
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.
Reports do not have to be boring and I really recommended that you put time into making them as good-looking as possible so users will want to interact with them.
I’m going to show you some examples of reports that I Continue reading “Lesson 11: Power Bi Use Case examples”
Welcome to this Power BI Course!
Subtitles for course are available in: English, Spanish and Persian.
View all lessons here: https://www.youtube.com/playlist?list=PLDz00l_jz6zx0wwS5HKFz5u-dEoAuRQMW
Persian Translation by: https://www.linkedin.com/in/seyed-sajad-mousavi-54035a139
Now that you have a better understanding of how Power BI works, Continue reading “Lesson 12: How much does Power BI cost?”
Come and join us to Curbal’s discord server where we can discuss anything about data and Power BI.
Click this link to access the server: https://discord.gg/QfKaqmf
See u there!!
Here you can download all the pbix files: rel=”nofollow”>https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
https://www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
#CURBAL #SUBSCRIBE
In today’s video I will answer Google’s most asked questions about Power BI? Ready?
Keynotes:
00:20 Is power BI free?
00:45 Is Power BI part of office 365?
01:00 Is Power BI open source?
01:45 Is Power BI easy to learn?
02:30 Is Power BI accesible Continue reading “I answer Google’s most asked questions on Power BI”