Struggling to use the Power BI Sort By feature on more than one column? Patrick has a trick for you to get it to work.
Did you know you could use conditional formatting to format one column by another in Power BI? Patrick shows you how! Download sample
Want to analyze your Power BI model without having the PBIX file? Marco Russo joins Patrick to show you how!
Not sure how to use VertiPaq Analyzer with Power BI to optimize your data model? Marco Russo joins Patrick to show you how!
Patrick shows you how to be efficient in Power BI Desktop using keyboard shortcuts for the DAX Editor. It is crazy bananas! Documentation: https://docs.microsoft.com/power-bi/desktop-accessibility
Adam looks at why the LastDate DAX function is returning the wrong date within Power BI Desktop. Breaking down a twitter conversation. Twitter thread: https://twitter.com/dhawalmehta/status/1183750809646972929 Marco's Blog: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/ Reza's Blog: https://radacad.com/lost-customers-dax-calculation-for-power-bi Calendar Table: https://www.youtube.com/watch?v=gyvhM5eiT0U Reduce data model size: https://www.youtube.com/watch?v=c-ZqToc85Yc Sample download
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup156 2 Minute Tuesday: https://guyinacu.be/easyparameters Patrick's tech video: https://guyinacu.be/referencequeries Interview: https://guyinacu.be/powerbiqueen Guy in a Cube courses: https://guyinacu.be/courses Sources Power Query – Function to Execute an SQL Procedure (@Laura_GB) Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI [...]
Phil sits down with us to walk through his process in debugging a slow Power BI report. This uses some new features in Power BI Desktop as well as using DAX Studio to get further insights. Connect with Phil Twitter: https://twitter.com/PhilSeamark Blog: https://dax.tips/
Patrick shows you how you can clear the Power BI Desktop model cache when troubleshooting DAX performance.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup150 2 Minute Tuesday: https://guyinacu.be/connecttools Patrick's tech video: https://guyinacu.be/powerapps Adam's tech video: https://guyinacu.be/reducedatasetsize Sources Chart With Different Scales (@dagdooe) Blank row in DAX (@FerrariAlberto) What’s new for SQL Server 2019 Analysis Services RC1 Change to Summarized Data Export behavior with [...]