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”
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.
A column of currency ended up with commas for both the thousands separator and the decimal point! How can you replace the last comma
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”
Power BI Challenge 14 asked participants to create an analysis of the current processes used by the medical responder with regard to emergency calls received. A compelling story and report built in Power BI is greatly encouraged. In this video, Continue reading “Emergency Services Analytics – Power BI Challenge 14 Submission, PART 2”