Advanced Modelling and Calculation Using the Power BI Designer

on YouTube ↗01h 08m

" summary

New Power BI Designer ships with an integrated authoring surface that combines Power Query, Power Pivot and Power View into a single .pbix workflow, delivers monthly updates, and lets users import millions of rows (demo mentions 12M) and publish a 25MB file to the Power BI service. It adds a formula bar with smarter intellisense, ability to save-broken measures, new DAX like ProductX/XNPV/DayDiff/PercentileX/MedianX, new visuals (combo, funnel, treemap, fill map, gauge) and bi-directional cross-filtering to handle many-to-many relationships out of the box.

AI-written summary · about

" chapters (7)

1. 0:00Power BI Designer intro
2. 4:33Getting started
3. 11:58Creating measures
4. 25:20New DAX functions
5. 39:33Relationship types and filtering
6. 52:16One-to-one relationships
7. 1:00:00Q&A

" related talks

• 01h 01mIntroducing the Reimagined Power BI PlatformJen Underwood · PASS BA Marathon 2015
• 48mCombine Power BI with External ToolsMiguel Félix · SQLBits 2023
• 43mBecome a Power BI Data Modeling Wizard using Tabular Editor 3Morten Lønskov, David L. Bojsen · SQLBits 2023
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 50mThe Path to Success with Power BI: Best PracticesPatrick LeBlanc, Adam Saxton · SQLBits 2023
• 51mData modeling for experts with Power BIMarc Lelijveld, Jeroen ter Heerdt · SQLBits 2023
• 58mReal world PowerBIMatt Davies · NDC Sydney 2017
• 30mEmpower every BI professional to do more with FabricZoe Douglas, Christian Wade · Microsoft Build 2023