Excel Unplugged

Tag Archives: PowerPivot

Dynamic Calendar with Power Query or Power BI – Take 2

I guess every data professional that has ever taken on the challenge of creating a data model either in Power Pivot or in Power BI knows the importance of the ...

Pivot Table vs Power Pivot or what is Power Pivot

This question or rather comparison never seizes to amaze me, since it’s just like comparing Eric Clapton to a Ford Mustang. It just can’t be done since ...

PowerPivot Inside Out (Part 2/3)

This is the second article of three. If you hadn’t read the first part yet, it is recommended that you do so. It talked about the basics of PowerPivot and ...

Power Pivot Inside Out (Part 1/3)

Power Pivot Inside Out is a three part series on 10 things you need to know about Power Pivot. Update 2022: we recently published a video on the Excel Olympics ...

Does a Power Pivot Pivot Table beat a regular Pivot Table

Does a Power Pivot Pivot Table beat a regular Pivot Table? Hands down, YES! If you would like to read about the comparison of definitions of the two, you can do so ...

Sorting months chronologically and not alphabetically in a Power Pivot based Pivot Table

Here is our “problem”. When you create a Pivot Table in Excel that has a date field and is based on data in Excel, you can Group that field by month and ...