Download Excel File: https://excelisfun.net/files/EMT1710.xlsx
Learn how lookup the last invoice payment date from a data set based on an invoice number. See 5 examples that can work in any version.
Topics:
1. (00:00) Introduction.
2. (00:20) MAXIFS function solution. Excel 2016 Continue reading “Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710”
Are you wanting to use streaming data? Patrick looks at Streaming Dataflows! A new way to integrate streaming data into your Power BI reports!
Streaming dataflows (preview)
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-streaming
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Continue reading “Exploring Streaming Dataflows in Power BI”
For this video, Greg will showcase how he utilized the newly available Deneb custom visual exclusively for his Enterprise DNA Power BI Challenge 17 partial submission, which received positive positive feedback from the community.
***** Video Details *****
00:00 Introduction
00:55 Overview of Continue reading “Exploring The Deneb Custom Visual In Power BI”
For today’s video, we’re going to unfold a challenge and a gift that we’d like to call the “Atomic Function Challenge” created by our chief content officer, Brian Julius.
One of the things on Brian’s learning goals this year is to Continue reading “Atomic Function Challenge – Discover A Multitude Of DAX And M Functions”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about the Measures of Central Location: Mean, Median, Mode and Moving Average. Learn about Skew. See how to use Power Query to import covid 19 data, calculate the 7-day moving average and plot Continue reading “Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!”
Download Excel File: https://excelisfun.net/files/EMT1770.xlsx
Learn how the basics of how to use the LET function and define variables within the formulas with repeating formula elements more efficient. Learn how to use LET and six other functions to create Continue reading “Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770”
