Power BI date table: create using DAX

In this video, Adam looks at how to create a Power BI date table using DAX. The end result uses a combination of the GENERATE(), ROW() and CALENDARAUTO() DAX functions to create a calculated table resulting in a Power BI date table. Using GENERATE and ROW instead of ADDCOLUMNS in DAX

Dynamically change chart axis in Power BI

In this video, Patrick builds on a blog post from Scott Senkeresty to dynamically change the axis of your visual within Power BI. This uses a combination of Power Query and DAX. Chris Cook - @Finalyst89 Scott Senkeresty – @ScottSenkeresty Dynamically changing chart axis http://tinylizard.com/dynamically-changing-chart-axis/

Fixing Power BI Quick Measures – Time calculations

In this video, Patrick shows how you can fix quick measures that break when you use dates with time calculations. Patrick referenced a blog from Kasper de Jong. You can find that here: Use the Power BI quick calcs with your own date table

Lots of Power BI updates and some DAX

Use Multiple Connections Between Tables (@PowerBITips) The ALL() Function in DAX (@ExceleratorBI) Responsive visualizations coming to Power BI Power BI Desktop July Feature Summary Power BI Service and Mobile June Feature Summary BONUS ITEMS: Data Privacy Settings In Power BI/Power Query, Part 4: Disabling Data Privacy Checks (@Technitrain) Integrate Power BI into Your Application: Part [...]

Fixing Time Calculations in Power BI

In this video, Patrick shows why you may hit some issues with time calculations and how to fix time. He typically sees this when using a Data Warehouse.

Tooltips, tooltips, tooltips in Power BI

In this video, Patrick shows how you can display multiple values within a tooltip for a visual. He walks through the DAX measure and also shows some pitfalls to look out for when it comes to filter context. DAX Sample Statement: Color Tooltip = var itemcount = DISTINCTCOUNT(StockItem[Color]) return IF(itemcount > 3, CONCATENATEX(TOPN(3,VALUES(StockItem[Color])),StockItem[Color],",")&" and more...", [...]

DAX, Maps and Power BI Features

The DAX Unichar() Function And How To Use It In Measures For Data Visualisation (@technitrain) ArcGIS Map in Power BI; Simple, But Insightful (@Rad_Reza) Create Column From Examples (@kpuls) Power BI Quick Measures is a Game Changer (@Paul_Turley) Get ready for the new Power BI navigation experience BONUS ITEMS: New Reports From Existing Datasets (@ExceleratorBI) [...]

DAX, Power BI in SSRS and more…

DAX Time Intelligence for Beginners (@ExceleratorBI) Defining the Components of a Modern Data Warehouse (@sqlchick) Publish Power BI Reports to SSRS On-premise Preview Now Available (@Paul_Turley) Help Improve DirectQuery! Introducing email subscriptions in Power BI: stay informed when it matters BONUS: Compare equivalent periods in DAX (@marcorus) Seven Steps for Using Data and Power BI [...]