For this tutorial, I want to showcase a couple methods on how you can create new records based on date fields using Power Query.
Melissa
***** Video Details *****
00:00 Introduction
00:45 Numeric equivalent
04:11 Setting data type
04:37 List.Dates
07:22 Date.From
07:50 Continue reading “How To Create New Records Based On Date Fields”
For today’s tutorial, I’d like to quickly go over the drill-through function in Power BI. This can be quite a powerful way to create a compelling navigation experience for the consumers of your report. I’ll Continue reading “Understanding Drill-Through Functionality And How To Use This In Power BI”
**UPDATE**: It is not possible to refresh custom connectors on the service and, there is now a Google Analytics connector on Power BI Desktop.
Welcome to this Power BI Course!
Subtitles for course are available in: English, Continue reading “Lesson 7: Intro to Power BI for developers – Power BI 101”
Download Excel File: https://excelisfun.net/files/EMT1732.xlsx
Learn how to:
1. (00:00) Introduction
2. (00:36) PivotTable and Pivot Charts in just one click!
3. (02:50) X Y Scatter Chart has NEVER been better!
4. (04:06) Summary, Closing and Video Links
Download Excel File: https://excelisfun.net/files/EMT1731.xlsx
Learn how to get stock market data for financial stocks Faster and Easier than ever using Microsoft 365 Excel:
1. (00:00) Introduction
2. (00:23) Stock Data Types. Including looking up columns Continue reading “Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731”
Download Excel File: https://excelisfun.net/files/EMT1734.xlsx
Learn how to:
1. (00:00) Introduction
2. (00:19) Power Query Create Data Types
3. (01:46) Records in Cell. View Car. Add Column
4. (02:07) Data Validation to select a full record in a Continue reading “Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.”
Download Excel File: https://excelisfun.net/files/EMT1733.xlsx
Open Excel Online: https://office.live.com/start/excel.aspx
Learn how to build a PivotTable in Excel Online.
In the comments, let me know what you think about this : )
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 Continue reading “Lesson 3: Intro to Power BI Desktop – Power BI 101”
Now that you know how to get Power BI Desktop and you know which version to get, let’s go in a little bit more detail of what Power BI Desktop is and what it can Continue reading “Lesson 4: Power BI Desktop Main Components – Power BI 101”
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 idea Continue reading “Lesson 5: Intro to Power BI Service – Power BI 101”
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
Have you tried the power bi mobile Continue reading “Lesson 6: Amazing Power BI Mobile features 📱- Power BI 101”
For this video, I’d like to talk about how you can make your Power BI reports look more application-like by simple hiding pages. This is a methodology that I’ve seen being used in many of Continue reading “Why Hiding Pages Make Your Power BI Reports More Application-Like – Power BI Design Tips”