Convert Text To Date And Group By Quarters - Power Query
Let's transform 3 characters text to date using Power Query, then group sales by Quarters by creating a Pivot Table in Excel.
Hope you find it useful.
Remember to subscribe, follow me in LinkedIn, and share!
Working file is available here:
https://docs.google.com/spreadsheets/...
#PowerQuery #MSExcel #DataAnalysis #DataTransformation #DataAnalyst #DateFromText #PivotTables #PowerQueryGirl #AlejandraHorvath #Empowered2XL #TimeSavingTips #AutomateYourWork