Download Excel File: https://excelisfun.net/files/EMT1782.xlsx
These two functions were released in March 16, 2022 and are in Beta at that time in Microsoft 365 Excel.
Learn about the 14 new functions in Microsoft 365 Excel.
Topics:
1. (00:00) Introduction
2. (00:31) TEXTSPLIT
3. (02:55) Continue reading “14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782”
How to get the Unique list of items appearing in a rectangular range. This solution uses the new TOCOL function released on March 16, 2022 to Microsoft 365 Office Insiders.
You have a bunch of sentences in Excel.
How do you find the last word in each cell using a formula?
The new TEXTAFTER function solves the problem.
Why does the new TEXTSPLIT function in Excel return #N/A errors at the right side? When does a double space create a blank cell? Solve both problems using optional arguments for Ignore_empty and Pad_With.
Way back in episode 2326, I spent 8+ minutes showing how to use LET to get the second to last word from a cell. Today, it still requires TEXTBEFORE, TEXTAFTER, and TRIM but can be done in 45 seconds.
As you progress in Power BI, you will gradually be working with more DAX measures and calculations. As a result, things can easily get cluttered. Today you will learn a few valuable tips and tricks on how to organize your DAX measures for a more efficient workflow. Hopefully this will help you and become a standard practice!
Watch the video for step by step instructions and a full explanation.
To summarize, Reid shows us how to add a new table and move our measures to it so they are together in one place.
He then shows us how to convert this into a folder, and then subsequently create subfolders to further organize your DAX measures in the model. Reid continues on to show us how we can have a measure in multiple locations if it makes sense.
What a great way to manage the measures as they grow in number!
***** Video Details *****
00:00 Introduction
00:33 Root folders
01:32 Subfolders
03:30 Actual Amount VTB
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial
Download Excel File: https://excelisfun.net/files/EMT1781.xlsm
These two functions were released in March 16, 2022 and are in Beta at that time.
Learn about the new HSTACK and VSTACK functions to Create Single Cell Cross Tabulated Report with Total Rows.
Topics:
1. (00:00) Continue reading “HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781”
Charts can be hard to understand sometimes. Ambiguity is never a good thing. Here are some tips for using data labels in Power BI to help your consumers better understand the meaning of the values.
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Some tips for your data labels in Power BI”
Today, a deeper dive into the new Excel functions TOCOL and TOROW.
Table of Contents
(0:00) Ignore errors with TOCOL
(0:46) Non-contiguous ranges with TOCOL
(0:56) 3-D Ranges with TOCOL
(1:26) Using TAKE and HSTACK
(2:01) VSTACK for Headings
What’s up with the wait time in Power BI Dataflows? Do we just live with it? What’s going on and what can we do about? Adam, has you covered!
Understanding and optimizing dataflows refresh
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh
📢 Become a member: <a Continue reading “So, we just wait???”
Fourteen new functions in Excel: TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, CHOOSECOLS, CHOOSEROWS, DROP, TAKE, EXPAND, TOCOL, TOROW, WRAPCOLS, WRAPROWS.
Links to Help topic for each:
TEXTSPLIT: https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
TEXTBEFORE: https://support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29
TEXTAFTER: https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4
VSTACK: https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c?ns=xlwaenduser&version=16&ui=en-us&rs=en-us&ad=us
HSTACK: Continue reading “Excel 14 Amazing New Functions in Excel – 2469”
Download Excel File: https://excelisfun.net/files/EMT1780.xlsm
These two functions were released in March 16, 2022 and are in Beta at that time.
Learn about the new HSTACK and VSTACK functions to Create Single Cell Reports With Total Row.
Topics:
1. (00:00) Introduction
2. (00:10) Continue reading “HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780”