Topic: Power Pivot

       Page 3 of 177 blog posts
blog post –

Use FIRSTNONBLANK and LASTNONBLANK instead of MIN and MAX #dax

You are probably used to think to FIRSTNONBLANK and LASTNONBLANK as DAX functions related to time-intelligence calculations (usually for semi-additive measures ). However, these functions have a syntax and a behavior that can be useful in other scenarios.  Read more

blog post –

Customize period comparison in DAX #powerpivot #dax #powerbi

I have seen many different types of custom calendars implemented in Power Pivot, Tabular, and DAX. I also wrote several articles ( week based calendars and time patterns ). However, there is a scenario that is hard to manage with the classical approaches,  Read more

blog post –

DAX Patterns 2015 book available now #daxpatterns #dax

In 2014 we published several articles in the DAX Patterns web site. We’ll continue to publish new patterns in 2015 (the first one later this month!), but in the meantime we created a first printed version of the patterns available: DAX Patterns 2015 .  Read more