All About Dates - Mastering Data Parsing & Dynamic Filtering in Power Query
ฝัง
- เผยแพร่เมื่อ 14 มี.ค. 2024
- Discover how to efficiently parse data types and dynamically filter dates in Power Query! Learn to create separate year, month, and day columns and effortlessly filter your dataset based on dynamic date ranges. Perfect for data analysts of all levels, this tutorial equips you with essential skills to optimize your use of Power Query. Watch now and enhance your Power Query expertise! Like, share, and subscribe for more!
Link to download practice dataset: docs.google.com/spreadsheets/...
#powerquery , #DataParsing, #DataFiltering, #DataAnalysis, #Excel, #MicrosoftPowerQuery, #DataManipulation, #DataCleaning, #DataTransformation, #DateFunctions
![แฟนแนวใด๋ - ยูริ โตเกียวมิวสิค [OFFICIAL MUSIC VIDEO ]](http://i.ytimg.com/vi/4_XVMuhhbsU/mqdefault.jpg)
Good stuff! Just a quick hint: you do not need to select all with ctrl-A tommake a table. Clicking anywhere in the range and using ctrl-T is enough.
Nice work. Thanks!
Thanks!
Don’t write the “dot” when writing the formula, continue writing the formula and press Tab, this will solve the extra writing
Very important!
For some reason they still won’t fix this. It’s been around for a few years and that workaround is very helpful
Do you have a video that shows how to use power query in order to sort data by financial year, like Oct-Sep? So it knows Oct is Q1.
That was a great solution to show year-over-year YTD revenue and I like how you went about troubleshooting the error 😀 By the way, the left video of your end screen is blocking the refreshed pivot table.
I'm glad you liked it! Thank you for letting me know about the end screen, I just fixed that!
@@excel4urparents242 Looks good!
@@excel4urparents242 Hi! Thanks for the great video! FYI The end screen issues are either not fixed or not replicated through.
any alternative for the "same period last year" calcuations in power query?I mean easier to grasp method.
The data type for the "Age" column should be changed to whole number I guess.Unless because you did'nt use it for your analysis
Great , but I can't convert 02/2024 format as a sample to date
Thank you for the comment! When I tested this, I found that selecting the Data Type as Date defaulted the date to the first of the month. After that, you can proceed to parse out the month and year using the Add Columns feature. Alternatively, in the Power Query editor under the Home tab, you can split the column by delimiter "/" to create separate year and month columns. It would be the month number at this point, but you can write a conditional-if column to get it to month names or create a new Customer column using the date syntax #date(year, month, day) to put it back into a date.
No dataset for us to try our hands on!
Hi! Thanks for the comment; the link to the dataset is now in the video description.
Speaking of dates, how about you and me, Friday night dinner athe Sizzler?