A common use-case of Power Automate is to automate workflows that begin with the receipt of emails. For example, [receive email] à [do action]. In order to do this, we need to know how to parse data within emails, and Continue reading “How To Parse Emails and Populate SharePoint Lists Using Power Automate”
Month: January 2022
Answering Wyn Hopkins Wordle Challenge
Wyn Hopkins built an Excel-based Wordle game. He saw my video on my Wordle Helper tool and challenged me to solve his game with my Excel file. The results are in.
Wyn’s video challenging me to play:
https://www.youtube.com/watch?v=D4uBZ8gdCTE
Wyn’s Continue reading “Answering Wyn Hopkins Wordle Challenge”
DAX Studio and DAX Optimization Masterclass – New Courses
We’re pleased to announce the release of two new courses on DAX developed by our resident DAX expert, Antriksh Sharma. Brian and Antriksh will give an overview on these courses, one of which can be considered as the most comprehensive Continue reading “DAX Studio and DAX Optimization Masterclass – New Courses”
Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773
Download Excel File: https://excelisfun.net/files/EMT1773.xlsx
Learn how to create a searchable data validation dropdown list in Microsoft 365 Excel. Learn how to use the XLOOKUP function to lookup a price from a Product Price Lookup Table.
Learn how to.
1. (00:00) Continue reading “Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773”
Using Python Sentiment Analysis
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
January 27th, 5pm New York (ET), 2pm Los Angeles (PT) , 10pm London (GMT)
January 28th, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Using Python Sentiment Analysis”
Create a date range parameter with Power BI Paginated Reports
How do you do a date range with the Paginated visual used with Power BI Paginated Reports? Adam shows you how to get a date range going without passing every day’s value within the range.
Create and use the paginated report Continue reading “Create a date range parameter with Power BI Paginated Reports”
How Parameters work with the Power BI Paginated Visual
Parameters for the Power BI Paginated visual can give you a lot of flexibility. Adam walks you through how to set up the parameters and breaks down what is actually happening with the values.
Create and use the paginated report visual
<a Continue reading “How Parameters work with the Power BI Paginated Visual”
How To Create Self-sorting Columns In Power BI
Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, Pavel Adam, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column Continue reading “How To Create Self-sorting Columns In Power BI”
Wordle Best Starting Words is AROSE not ADIEU – Episode 2463
Everyone has their theories on the best starting word for the Wordle game. A lot of people suggest ADIEU. But when you look at the frequency of each letter in the 8000 possible words, a better start word has Continue reading “Wordle Best Starting Words is AROSE not ADIEU – Episode 2463”
Enterprise DNA Partners Up With Zebra BI
In the coming days, we’re going to be doing a series of announcements for upcoming new technologies, initiatives, partnerships, content, and innovations in the Enterprise DNA community.
Today, we’d like to put the focus on a much-awaited tech partnership with Zebra Continue reading “Enterprise DNA Partners Up With Zebra BI”
WORDLE Helper In Excel – Solve Wordle Faster! – Episode 2462
I love the Wordle game. One game a day. Three minutes. As I played for the first week, I wondered if Excel could help. It can!
Note that this workbook requires a recent Excel version due to the FILTER formula. You Continue reading “WORDLE Helper In Excel – Solve Wordle Faster! – Episode 2462”
REPLAY Power BI tips from the Pros – LIVE (Jan 22, 2022)
Join us live as we answer your questions about Power BI!
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment Continue reading “REPLAY Power BI tips from the Pros – LIVE (Jan 22, 2022)”