Topic: Power Pivot

       Page 2 of 177 blog posts
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

blog post –

Challenge your #dax skills with DAX Puzzle #powerbi #powerpivot

Last week we launched a new page in SQLBI website: DAX Puzzle (you can also use www.daxpuzzle.com ). The idea is very simple: we describe a scenario, we ask to solve a problem in that scenario and we might provide some hint to help you finding the solution.  Read more

blog post –

Don’t ignore the Context Transition in #dax

Almost 3 years ago I wrote an article with the rules for DAX code formatting . If you quickly look at the article, you might think that it is all about readability of the code, and this is fundamentally true. But there two rules that have a particular  Read more

blog post –

Back to the basic: #dax primers for new #powerbi users

The growing adoption of Power BI Desktop is gathering new users of the DAX language. At the same time, there are a few new features, such as bidirectional filter propagation, that introduce new concepts to existing knowledge. For this reason, in the last  Read more