Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864

Описание к видео Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864

Here is link: https://www.mrexcel.com/products/the-... or Amazon: https://www.amazon.com/Transformative...
Mike "excelisfun" Girvin's 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel.

Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.

Remember:
Microsoft and Lotus though that 1900 was a leap year and so they added 2/29/1900 as a date in Excel. But if you import your dates into Excel or the reverse, all dates work.

Комментарии

Информация по комментариям в разработке