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 [...]
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup148 Tech Video: https://guyinacu.be/hierarchy Upcoming Training Create and distribute Power BI reports for beginners – Atlanta – October 2019 Sources Dynamic Visuals using Buttons (@PowerBITips) Conditional Formatting for Single Value Cards (@HavensBI) DAX Fusion (@Phil_Seamark) Connecting Azure Analysis [...]
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup146 Tech Video: https://guyinacu.be/detectdatachanges Sources Power BI Visual Header Tooltip (@pkamasani) Filtering the Top 3 products for each category in Power BI (@marcorus) What Fields to Hide in Your Power BI Solution? (@rad_reza) Power BI introduces service availability notifications Introducing the new look [...]
Need to work with hours and minutes in your Power BI report? How do you slice by that grain? Patrick shows you a way you can work with time in Power BI Desktop. Download sample report Want to download the sample Power BI Desktop report? Hit the download button below.
Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a little DAX into Power BI Desktop to get this going!
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup137 2 Minute Tuesday: https://guyinacu.be/multiselecttitles Patrick's tech video: https://guyinacu.be/kpiscorecard Adam's tech video: https://guyinacu.be/columnprofiling SQL Saturday Atlanta: https://www.sqlsaturday.com/845/eventhome.aspx DAX Training: - https://sqlbi.com - https://www.youtube.com/curbalen - https://exceleratorbi.com.au/ - https://radacad.com/ Sources CREATE A DYNAMIC TITLE IN POWER BI (UPDATED) (@LindsayPinchot) Move Your Shared Tables to Dataflow; [...]