Загрузка...

Using Monkey Tools - Building dynamic 4-4-5 calendar tables without coding!

Monkey Tools contains a collection of Query Monkeys who will inject useful Power Queries into your workbooks on demand.

One of the essential data model components for any type of calendar intelligence is building a dedicated Calendar table for your Power Pivot model. While it is always best to connect directly to the "blessed" version of the calendar from your IT department, what if they don't provide one? In this video, we'll look at how Monkey Tools Calendar Monkey allows you to VERY easily set up a customized calendar table that dynamically refreshes to cover the entire fiscal year(s) you data spans - even if you use a 4-4-5, 4-5-4 or 5-4-4 calendar setup. And the best part? It will automatically expand every time you refresh your data model!

100% user interface driven, 0% coding, it creates the required Power Query for you - resulting in a solution that is 1000% awesome! You definitely need to meet this monkey!

Видео Using Monkey Tools - Building dynamic 4-4-5 calendar tables without coding! канала Skillwave Training
Яндекс.Метрика
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять