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

Power BI Updates, tips and tricks and more… (May 13, 2019)

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; [...]

Power BI Updates, tips and tricks and more… (May 13, 2019)2019-05-12T08:51:29-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

Multi-select Dynamic Titles in Power BI Desktop

After the dynamic titles in Power BI Desktop video, we had questions about how to do multi-select values. Patrick shows you how to do it! Demo files: https://guyinacu.be/demofiles

Multi-select Dynamic Titles in Power BI Desktop2019-05-07T07:49:45-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

Using DAX to format a list of values in Power BI Desktop

Alberto Ferrari joins Patrick to walk through how you can use DAX to format a list of values within Power BI Desktop. This takes the concatenate values quick measure to the next level. Original Quick Measure video Alberto's article

Using DAX to format a list of values in Power BI Desktop2019-03-11T06:48:33-05:00

Power BI Tooltips and report performance

Patrick looks at a customer scenario where he found Power BI tooltips causing report performance issues. He shows how to identify and then a possible solution.

Power BI Tooltips and report performance2019-02-24T18:32:43-05:00

Power BI: Hiding future dates for calculations in DAX

Marco Russo joins Patrick to discuss how to hide future dates for calculations in DAX. Marco walks through Power BI Desktop with some examples that work and don't work. SQLBI Article: Hiding future dates for calculations in DAX

Power BI: Hiding future dates for calculations in DAX2019-02-13T07:56:47-05:00