[DAX] Window Functions & Tabular Editor 3 (with Daniel Otykier)

The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX debugger to see what we can learn from them.
GUEST BIO
Daniel is a Microsoft Data Platform MVP and CTO of Tabular Editor ApS - the company behind the tool. Tabular Editor is a popular tool for managing and editing Microsoft Power BI, Analysis Services, and Azure Analysis Services models. With a background in data analysis and business intelligence, Daniel has a strong understanding of the challenges and needs of BI professionals. He developed the Tabular Editor as a solution to streamline the process of managing and editing tabular models, and it has since become a go-to tool for many in the industry.
RELATED CONTENT 🔗
Tabular Editor Site -- tabulareditor.com
Daniel's Twitter -- / dotykier
New DAX Functions (Dec '22 Power BI Release) -- powerbi.micros...
Data Goblin's Keyboard Shortcuts -- data-goblins.c...
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consult...
HAVENS CONSULTING PAGES 📄
Home Page -- www.havensconsu...
Blog -- www.havensconsu...
Blog Files -- www.havensconsu...
Files & Templates -- www.havensconsu...
Consulting Services -- www.havensconsu...
Online Course -- www.havenscons...
Contact & Support -- www.havensconsu...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #tabulareditor

[@DeronHuskey]

Great presentation and I'm sorry I missed it. I've seen your livestreams before and I don't recall the chat replay...that was very helpful seeing how the conversation progressed.
Thanks to Daniel and Reid.

[@HavensConsulting]

Absolutely! It should be on almost all my videos :)

[@katharinecooney9727]

Many thanks Daniel and Reid for this. I missed the name of the blogpost Daniel referred to for an in-depth description of the new functions - could you please provide?

[@HavensConsulting]

Sure thing! Also added to the description. powerbi.microsoft.com/en-au/blog/power-bi-december-2022-feature-summary

[@youjohnny16]

Super useful livestream. Thanks Daniel / Reid.

[@rahulhanks4937]

Well great help haven consulting for Bi developer

[@Baldur1005]

AS far as shortcuts are concerned I would kill for having Format Painter shortcut inside Power BI. Now let's wait for Miguel Myers to enter the show ;)

[@kaly5834]

Daniel/Reid .. Wonderful presentation. Q: I am thinking about purchasing and using Tabular Editor 3. But I still need to keep TE 2 on my desktop in case I do a demo or need to teach someone how to use the free version. Is that possible? to have both applications installed at the same time? Someone mentioned to me in the past that it was not possible, I can't remember what issues they ran into, but I don't want to install TE3 until I get my subscription license approved thru work. THX

[@HavensConsulting]

Yup! I have both installed, both as an external tool icon, and I use both in Demos :)

[@sergiyrazumov5518]

Thanks for the presentation, it was very interesting. Feature with diagram in TE3 Debugger is simply mind-blowing 🤯
Can you share that link to the blog post about TE3 Keyboard shourtcuts usecases?
Many thanks in advance

[@HavensConsulting]

Sure thing! Here you go data-goblins.com/power-bi/tabular-editor-keyboard-shortcuts

[@sergiyrazumov5518]

@@HavensConsulting thanks a lot, Reid 🙏