Mark as Date Table in Power BI Desktop is finally here! In this video, Patrick takes what Adam did with a custom date table and shows you how you can use Mark as Date Table in Power BI Desktop. This feature was introduced in the February 2018 release of Power BI Desktop. Mark as Date [...]
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
Patrick and I will be coming to Europe at the end of February! We would love to meet you and have some awesome conversations around Power BI, or anything really. We will be at SQL Bits from February 21st thru the 24th and will be delivering two full-day pre-conference sessions. One on Power BI embedding [...]
Power BI Quiz (Test Prep for Certification) (@rsaprano) The definitive guide to ALLSELECTED (@FerrariAlberto) Share reports with your teams and partners Connect to tens of thousands of datasets on data.world with the new connector for Power BI Desktop Power BI Desktop February Feature Summary BONUS ITEMS: Joining tables In Power BI using Power Query and/or [...]
We look at a Power BI tutorial on how to properly complete the app registration within Azure Active Directory (AAD). This power bi tutorial is needed as we see many questions about the proper configuration for a Power BI app registration regarding which settings to use. App registrations are needed to use the Power BI [...]
In this video, Adam shows you how you can import KPIs from Excel into Power BI. Once in Power BI, you can use the KPI in a table or matrix. Documentation: Import and display KPIs in Power BI
