The new EVALUATEANDLOG DAX function is great, but how do you actually use it in conjunction with SQL Profiler. This articles shows how and also demonstrates how to configure SQL Profiler as an external tool for Power BI Desktop.
If you use power bi direct query, you can define a date table at the source or in power bi. You can create a date table in Power BI. The table created in Power BI is in import mode. Power BI will enable mixed-mode queries.
In this 3 minute post, you'll learn how to modify the custom theme file in Power BI to toggle the visibility of the calendar icon in the Date Slicer. This feature was introduced back in the March 2022 PBI Update, but it lacks the GUI option to turn on or off the calendar icon.
What if when Power BI was released all those years ago that it defaulted to table and matrix totals simply summing the rows? Let's explore this alternate reality and how you would handle displaying an alternate summary of information in a table or matrix.