Topic: Power BI

       Page 5 of 74 blog posts
blog post –

Leverage INTERSECT to apply relationships in DAX

If you are used to virtual relationships in DAX (see Handling Different Granularities in DAX ), you probably use the following pattern relatively often: [Filtered Measure ] := CALCULATE (     <target_measure>,     FILTER  Read more

blog post –

Happy Birthday Power BI #powerbi

Power BI has been on the market one year. My biggest concern, when the product was still in private beta, was the promise of monthly releases made by Microsoft. Today, I can say that the promise was real. I see a long road ahead, in terms of features  Read more

blog post –

Leverage Analyze in Excel for your Power Pivot model

Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example, it does  Read more

blog post –

A warm welcome to Power BI Embedded #powerbi

I wrote this blog post with Alberto Ferrari . A few days ago, during the Build conference, Microsoft announced the availability, although still in preview, of Power BI Embedded . In a few words, Power BI Embedded lets you embed Power BI reports in your  Read more

blog post –

GROUPBY vs SUMMARIZE in #dax #powerbi #powerpivot

If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it’s easy to find scenarios where you get unexpected  Read more