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+00:00

Power BI Roadmap, DAX Games, Gateway management and more… (January 28, 2019)

Temple of DAX – 3D (@PhilSeamark) Curbal Tech News on Dataflows (@CurbalEN) Power BI Roadmap Announcements In The April 2019 Release Notes (@cwebb_bi) Business Applications Release Notes On-premises data gateway management in the Power platform admin center Power BI Report Server Update – January 2019 Paginated Report Bear has big news! BONUS ITEMS: Storytelling with [...]

Power BI Roadmap, DAX Games, Gateway management and more… (January 28, 2019)2019-01-28T06:09:37+00:00

Happy New Year! Power BI Roadmap, Tab Order and more… (January 7, 2019)

Tab Order Enhances Power BI Report Accessibility (@mmarie) What has happened in the DAX world in 2018 (@marcorus) Happy New Year from Power BI Desktop! Power BI Service and Mobile November & December Feature Summary Power BI Roadmap BONUS ITEMS: ArcGIS Maps for Power BI – Further capabilities and other information (@blogenginenet) Interviews from PASS [...]

Happy New Year! Power BI Roadmap, Tab Order and more… (January 7, 2019)2019-01-07T08:12:42+00:00

Power BI Desktop And Role-Playing Dimensions: Can you do it?

In this video, Patrick talks about Power BI Desktop and role-playing dimensions. Can you even do this in Power BI Desktop? Patrick shows you why one particular way is not recommended as it will cause trouble. And then show you how you can use DAX within Power BI Desktop to take this to the next [...]

Power BI Desktop And Role-Playing Dimensions: Can you do it?2018-09-05T06:02:53+00:00

Power BI URL Filter Updates (August 2018)

In this video, Patrick looks at the recent updates to using the Power BI URL Filter. The update to using URL Filter parameters in Power BI include updates to operators along with the ability to use more than strings and spaces in table names! Blog: https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/ Documentation: https://docs.microsoft.com/en-us/power-bi/service-url-filters Demo PBIX: https://guyinacu.be/demos

Power BI URL Filter Updates (August 2018)2018-08-22T08:21:22+00:00

Power BI Tutorial: Dynamically Filter By Today’s Date

In this Power BI Tutorial, Patrick looks at how to dynamically filter by today's date. Using a date table, you can create a DAX measure that can then be used as a Power BI report-level filter to dynamically filter by today's date within Power BI Desktop.

Power BI Tutorial: Dynamically Filter By Today’s Date2018-08-08T08:16:37+00:00

Power BI Sudoku, Custom fonts, DAX and more… (June 25, 2018)

Fun with DAX – Sudoku (@PhilSeamark) Custom Web Fonts and Icons in Power BI (@dataveld) POWER BI REPORT SERVER DEVOPS (Trisha McCormick) Automatically expand all fields from a JSON document in Power BI and Power Query (@TheBIccountant) Correct calculate of age in DAX from birthday (@marcorus) BONUS ITEMS: Segmented Filtering with Slicers (@PowerBITips) More Details [...]

Power BI Sudoku, Custom fonts, DAX and more… (June 25, 2018)2018-06-25T08:54:49+00:00

Combine Power BI Report Tooltips using DAX

In this video, Patrick shows you how to combine Power BI Report Tooltips using DAX. Just a little bit of DAX! This can be useful when you want to use a single report tooltip for multiple Power BI visuals.

Combine Power BI Report Tooltips using DAX2018-05-30T09:12:08+00:00

Debug DAX using Variables in Power BI

In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is. SQL BI DAX Formatter DAX [...]

Debug DAX using Variables in Power BI2018-05-21T21:03:45+00:00

Power BI, Excel, USAFacts and more… (April 19, 2018)

Compound Growth using DAX (@ExceleratorBI) Power BI and Excel; More than just an Integration (@Rad_Reza) Drill Down & Up in Power BI Mobile apps Join the Power BI team at Microsoft Build USAFacts breaks down government financial data with Power BI BONUS ITEMS: DAX Best Practices (@marcorus) DAX Optimization Examples (@marcorus) Reordering Multiple Columns With [...]

Power BI, Excel, USAFacts and more… (April 19, 2018)2018-04-19T10:24:16+00:00