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).
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
|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