Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify data into GOOD or BAD (requires clean-up).
Category Archives: Data Model
Understanding Data Categories in Power Pivot
 |
It is a powerful but often ignored feature of Power Pivot. It allows you to describe the meaning of the data column – independent of its field name. Estimated reading time 8 min |
Continue reading Understanding Data Categories in Power Pivot
Repairing Month Sorting Order in Power Pivot – Part 2
Here is the Power Pivot way of customizing sort order for any table.
Read the previous article first.
Estimated reading time 8 min
Continue reading Repairing Month Sorting Order in Power Pivot – Part 2
Repairing Month Sorting Order in Power Pivot – Part 1
 |
If you use text month in a Power Pivot Table, it is sorted in alphabetical order.
Here is the solution to the problem. Quick Solution time 2 min
|
Continue reading Repairing Month Sorting Order in Power Pivot – Part 1