Topic: Tabular

       Page 3 of 159 blog posts
blog post –

BLANK and Boolean functions like IF in #dax

A recent change in the DAX language transformed the behavior of IF statement, so that it should not return BLANK but only TRUE/FALSE if the results should be logical expressions. In that case, the BLANK is transformed in a FALSE condition. For example,  Read more

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 –

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