Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890

Download Excel File: excelisfun.net/files/EMT1890.xlsx
Learn how to fix PivotTable When Dates Not Grouping.
Topics:
1. (00:00) Introduction
2. (00:03) Dates not grouping in PivotTable
3. (00:11) Fix #1: Excel Options
4. (00:26) Fix #2: Dates are Text
5. (00:43) Fix #3 Edit Power Query to Add Data Type For Data
6. (01:18) Refresh PivotTable Cache
7. (01:57) Group and Ungroup feature
8. (02:27) Load Power Query query directly to PivotTable Cache.
9. (03:02) Closing

Using the gear icon setting button below the video, you can watch subtitles in these 31 languages: Afrikaans, Arabic, Bangla, Chinese, Dutch, Filipino, French, German, Hindi, Indonesian, Irish, Italian, Japanese, Khmer, Malagasy, Malay, Malayalam, Nepali, Persian, Polish, Portuguese, Russian, Spanish, Somali, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese.
Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish.





#excel #microsoft #excelisfun #excelcourse #pivottable #pivottables #gruop


#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions