Power BI: Use DAX to get relative dates

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!

Power BI: Use DAX to get relative dates2019-05-12T09:02:19-05:00

Column Profiling in Power BI Desktop

Adam walks through column profiling within the Power BI Desktop. This includes the latest updates with the general availability (GA) within the April 2019 Power BI Desktop release. Demo files: https://guyinacu.be/demofiles

Column Profiling in Power BI Desktop2019-05-07T16:00:13-05:00

Power BI: Build a custom KPI scorecard

Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles

Power BI: Build a custom KPI scorecard2019-05-07T15:47:48-05:00

Power BI Walkthrough: Analysis Services Live Connect

Adam walks through how to setup a live connection to Analysis Services, or Azure Analysis Services, in Power BI Desktop. This also involves getting things working with the On-Premises Data Gateway.

Power BI Walkthrough: Analysis Services Live Connect2019-04-28T17:10:13-05:00

Cross-report Drillthrough in Power BI

Patrick shows the magic of getting cross-report drillthrough working in Power BI. He teaches you the clicks to getting this going successfully. Demo files: https://guyinacu.be/demofiles

Cross-report Drillthrough in Power BI2019-04-28T16:55:06-05:00

Taking Buttons in Power BI Desktop to the Next Level

Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your Power BI Reports shine. Connect with Amanda on Twitter: https://twitter.com/MissAmandaN

Taking Buttons in Power BI Desktop to the Next Level2019-04-25T08:08:38-05:00

Power BI Get Data: Import vs. DirectQuery vs. Live

Import vs. DirectQuery vs. Live connection. Which do you choose and why in Power BI? Adam looks at the three options when creating reports in Power BI Desktop. DirectQuery in SQL Server 2016 Analysis Services Whitepaper Data sources supported by DirectQuery in Power BI

Power BI Get Data: Import vs. DirectQuery vs. Live2019-04-14T06:34:52-05:00

A look at the Power BI Desktop Model View

Patricks walks through what you can do with the Power BI Desktop Model View. From bulk operations to organizing your relationships in the Power BI data model, there are a lot of great things.

A look at the Power BI Desktop Model View2019-04-14T06:25:43-05:00