https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Turning-445-Calendar-Summary-Table-to-Usable-Table/m-p/151548#M19 <P><!-- Shady DOM styles for custom-style --><!-- Shady DOM styles for dom-template --><!-- Shady DOM styles for dom-repeat --><!-- Shady DOM styles for array-selector --><!-- Shady DOM styles for dom-if --><!-- Shady DOM styles for app-box --><!-- Shady DOM styles for app-drawer --><!-- Shady DOM styles for iron-media-query --><!-- Shady DOM styles for app-drawer-layout --><!-- Shady DOM styles for app-header-layout --><!-- Shady DOM styles for app-header --><!-- Shady DOM styles for app-scrollpos-control --><!-- Shady DOM styles for app-toolbar --><!-- Shady DOM styles for yt-guide-manager --><!-- Shady DOM styles for iron-meta --><!-- Shady DOM styles for iron-meta-query --><!-- Shady DOM styles for iron-icon --><!-- Shady DOM styles for paper-ripple --><!-- Shady DOM styles for paper-icon-button --><!-- Shady DOM styles for paper-icon-button-light --><!-- Shady DOM styles for paper-icon-item --><!-- Shady DOM styles for paper-item-body --><!-- Shady DOM styles for paper-item --><!-- Shady DOM styles for paper-toggle-button --><!-- Shady DOM styles for iron-iconset-svg --><!-- Shady DOM styles for yt-icon --><!-- Shady DOM styles for ytd-account-settings --><!-- Shady DOM styles for ytd-channel-custom-gadget-renderer --><!-- Shady DOM styles for paper-material --><!-- Shady DOM styles for paper-button --><!-- Shady DOM styles for yt-endpoint --><!-- Shady DOM styles for yt-formatted-string --><!-- Shady DOM styles for ytd-expander --><!-- Shady DOM styles for fade-in-animation --><!-- Shady DOM styles for fade-out-animation --><!-- Shady DOM styles for opaque-animation --><!-- Shady DOM styles for paper-tooltip --><!-- Shady DOM styles for ytd-badge-supported-renderer --><!-- Shady DOM styles for ytd-video-meta-block --><!-- Shady DOM styles for ytd-channel-video-player-renderer --><!-- Shady DOM styles for ytd-comment-history-block-header-renderer --><!-- Shady DOM styles for yt-img-shadow --><!-- Shady DOM styles for ytd-backstage-image-renderer --><!-- Shady DOM styles for ytd-button-renderer --><!-- Shady DOM styles for ytd-toggle-button-renderer --><!-- Shady DOM styles for ytd-menu-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-hover-text-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-playback-status-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-resume-playback-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-side-panel-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-time-status-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-toggle-button-renderer --><!-- Shady DOM styles for ytd-thumbnail --><!-- Shady DOM styles for ytd-notification-text-renderer --><!-- Shady DOM styles for ytd-video-renderer --><!-- Shady DOM styles for ytd-comment-history-entry-renderer --><!-- Shady DOM styles for ytd-author-comment-badge-renderer --><!-- Shady DOM styles for iron-autogrow-textarea --><!-- Shady DOM styles for paper-input-char-counter --><!-- Shady DOM styles for paper-input-container --><!-- Shady DOM styles for paper-input-error --><!-- Shady DOM styles for iron-a11y-announcer --><!-- Shady DOM styles for iron-input --><!-- Shady DOM styles for paper-input --><!-- Shady DOM styles for paper-textarea --><!-- Shady DOM styles for paper-spinner --><!-- Shady DOM styles for paper-spinner-lite --><!-- Shady DOM styles for ytd-backstage-image-select-renderer --><!-- Shady DOM styles for ytd-commentbox --><!-- Shady DOM styles for ytd-comment-reply-dialog-renderer --><!-- Shady DOM styles for ytd-creator-heart-renderer --><!-- Shady DOM styles for ytd-comment-action-buttons-renderer --><!-- Shady DOM styles for ytd-comment-dialog-renderer --><!-- Shady DOM styles for ytd-pinned-comment-badge-renderer --><!-- Shady DOM styles for ytd-comment-renderer --><!-- Shady DOM styles for yt-next-continuation --><!-- Shady DOM styles for ytd-comment-replies-renderer --><!-- Shady DOM styles for ytd-comment-thread-renderer --><!-- Shady DOM styles for ytd-notification-renderer --><!-- Shady DOM styles for iron-collapse --><!-- Shady DOM styles for ytd-generic-faq-question-renderer --><!-- Shady DOM styles for ytd-faq-section-renderer --><!-- Shady DOM styles for ytd-purchase-item-renderer --><!-- Shady DOM styles for ytd-simple-text-section-renderer --><!-- Shady DOM styles for iron-image --><!-- Shady DOM styles for paper-card --><!-- Shady DOM styles for ytd-unlimited-manage-subscription-page-renderer --><!-- Shady DOM styles for ytd-unlimited-page-feature-info-renderer --><!-- Shady DOM styles for ytd-single-ypc-offer-renderer --><!-- Shady DOM styles for ytd-collapsible-ypc-offer-renderer --><!-- Shady DOM styles for iron-overlay-backdrop --><!-- Shady DOM styles for paper-dialog --><!-- Shady DOM styles for ytd-unlimited-page-header-renderer --><!-- Shady DOM styles for ytd-single-ypc-offer-list-renderer --><!-- Shady DOM styles for ytd-ypc-offers-list-renderer --><!-- Shady DOM styles for ytd-channel-about-metadata-renderer --><!-- Shady DOM styles for ytd-subscribe-button-renderer --><!-- Shady DOM styles for ytd-channel-renderer --><!-- Shady DOM styles for ytd-child-video-renderer --><!-- Shady DOM styles for ytd-playlist-custom-thumbnail-renderer --><!-- Shady DOM styles for ytd-playlist-video-thumbnail-renderer --><!-- Shady DOM styles for ytd-show-custom-thumbnail-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-bottom-panel-renderer --><!-- Shady DOM styles for ytd-playlist-thumbnail --><!-- Shady DOM styles for ytd-playlist-renderer --><!-- Shady DOM styles for ytd-radio-renderer --><!-- Shady DOM styles for ytd-show-renderer --><!-- Shady DOM styles for ytd-channel-featured-content-renderer --><!-- Shady DOM styles for ytd-compact-link-renderer --><!-- Shady DOM styles for ytd-crisis-health-renderer --><!-- Shady DOM styles for ytd-single-action-emergency-support-renderer --><!-- Shady DOM styles for ytd-emergency-onebox-renderer --><!-- Shady DOM styles for ytd-exploratory-results-renderer --><!-- Shady DOM styles for ytd-feed-entry-renderer --><!-- Shady DOM styles for ytd-message-renderer --><!-- Shady DOM styles for paper-radio-button --><!-- Shady DOM styles for paper-radio-group --><!-- Shady DOM styles for ytd-feedback-elicitation-single-question-renderer --><!-- Shady DOM styles for ytd-grid-channel-renderer --><!-- Shady DOM styles for ytd-grid-movie-playlist-renderer --><!-- Shady DOM styles for ytd-grid-playlist-renderer --><!-- Shady DOM styles for ytd-grid-show-renderer --><!-- Shady DOM styles for ytd-notification-multi-action-renderer --><!-- Shady DOM styles for ytd-standalone-ypc-badge-renderer --><!-- Shady DOM styles for ytd-standalone-badge-supported-renderer --><!-- Shady DOM styles for ytd-grid-video-renderer --><!-- Shady DOM styles for ytd-music-pass-small-feature-info-renderer --><!-- Shady DOM styles for ytd-grid-renderer --><!-- Shady DOM styles for ytd-music-pass-feature-info-renderer --><!-- Shady DOM styles for ytd-newspaper-hero-video-renderer --><!-- Shady DOM styles for ytd-newspaper-mini-video-renderer --><!-- Shady DOM styles for ytd-newspaper-renderer --><!-- Shady DOM styles for ytd-playlist-video-renderer --><!-- Shady DOM styles for ytd-playlist-video-list-renderer --><!-- Shady DOM styles for ytd-search-history-query-renderer --><!-- Shady DOM styles for ytd-search-no-results-renderer --><!-- Shady DOM styles for ytd-promoted-video-renderer --><!-- Shady DOM styles for ytd-search-pyv-renderer --><!-- Shady DOM styles for ytd-compact-promoted-item-renderer --><!-- Shady DOM styles for ytd-expanded-shelf-contents-renderer --><!-- Shady DOM styles for ytd-grid-movie-renderer --><!-- Shady DOM styles for ytd-grid-radio-renderer --><!-- Shady DOM styles for yt-horizontal-list-renderer --><!-- Shady DOM styles for ytd-vertical-list-renderer --><!-- Shady DOM styles for ytd-shelf-renderer --><!-- Shady DOM styles for yt-search-query-correction --><!-- Shady DOM styles for yt-did-you-mean-renderer --><!-- Shady DOM styles for yt-including-results-for-renderer --><!-- Shady DOM styles for yt-no-results-found-showing-results-for-renderer --><!-- Shady DOM styles for yt-results-without-quotes-renderer --><!-- Shady DOM styles for yt-showing-results-for-renderer --><!-- Shady DOM styles for yt-masthead-ad-renderer --><!-- Shady DOM styles for ytd-video-masthead-ad-renderer --><!-- Shady DOM styles for ytd-alert-renderer --><!-- Shady DOM styles for ytd-channel-legal-info-renderer --><!-- Shady DOM styles for paper-tab --><!-- Shady DOM styles for paper-tabs --><!-- Shady DOM styles for ytd-channel-avatar-editor --><!-- Shady DOM styles for ytd-expandable-tab-renderer --><!-- Shady DOM styles for ytd-c4-tabbed-header-renderer --><!-- Shady DOM styles for ytd-playlist-sidebar-renderer --><!-- Shady DOM styles for ytd-navigation-dropdown-item-renderer --><!-- Shady DOM styles for ytd-privacy-dropdown-item-renderer --><!-- Shady DOM styles for paper-menu-grow-height-animation --><!-- Shady DOM styles for paper-menu-grow-width-animation --><!-- Shady DOM styles for paper-menu-shrink-width-animation --><!-- Shady DOM styles for paper-menu-shrink-height-animation --><!-- Shady DOM styles for iron-dropdown --><!-- Shady DOM styles for paper-menu-button --><!-- Shady DOM styles for paper-dropdown-menu --><!-- Shady DOM styles for paper-dropdown-menu-light --><!-- Shady DOM styles for paper-listbox --><!-- Shady DOM styles for ytd-dropdown-renderer --><!-- Shady DOM styles for ytd-playlist-header-renderer --><!-- Shady DOM styles for ytd-survey-trigger-renderer --><!-- Shady DOM styles for ytd-banner-promo-renderer --><!-- Shady DOM styles for ytd-channel-metadata-renderer --><!-- Shady DOM styles for ytd-sub-feed-option-renderer --><!-- Shady DOM styles for ytd-sub-feed-selector-renderer --><!-- Shady DOM styles for ytd-browse-feed-actions-renderer --><!-- Shady DOM styles for paper-menu --><!-- Shady DOM styles for paper-submenu --><!-- Shady DOM styles for yt-reload-continuation --><!-- Shady DOM styles for yt-supported-renderers --><!-- Shady DOM styles for yt-dropdown-menu --><!-- Shady DOM styles for ytd-sort-filter-sub-menu-renderer --><!-- Shady DOM styles for ytd-channel-sub-menu-renderer --><!-- Shady DOM styles for ytd-backstage-post-dialog-renderer --><!-- Shady DOM styles for ytd-comment-simplebox-renderer --><!-- Shady DOM styles for ytd-comments-header-renderer --><!-- Shady DOM styles for ytd-item-section-renderer --><!-- Shady DOM styles for ytd-search-filter-renderer --><!-- Shady DOM styles for ytd-search-filter-group-renderer --><!-- Shady DOM styles for ytd-search-sub-menu-renderer --><!-- Shady DOM styles for ytd-comments --><!-- Shady DOM styles for ytd-channel-age-gate-renderer --><!-- Shady DOM styles for ytd-section-list-renderer --><!-- Shady DOM styles for yt-app-context --><!-- Shady DOM styles for yt-service --><!-- Shady DOM styles for ytd-two-column-browse-results-renderer --><!-- Shady DOM styles for ytd-browse --><!-- Shady DOM styles for iron-pages --><!-- Shady DOM styles for ytd-watch-card-album-list-renderer --><!-- Shady DOM styles for ytd-watch-card-collage-renderer --><!-- Shady DOM styles for ytd-watch-card-single-image-renderer --><!-- Shady DOM styles for ytd-watch-card-video-list-renderer --><!-- Shady DOM styles for ytd-generic-watch-card --><!-- Shady DOM styles for ytd-artist-watch-card-renderer --><!-- Shady DOM styles for ytd-show-watch-card-renderer --><!-- Shady DOM styles for ytd-watch-card-hero-video-renderer --><!-- Shady DOM styles for ytd-watch-card-rich-header-renderer --><!-- Shady DOM styles for ytd-watch-card-compact-video-renderer --><!-- Shady DOM styles for ytd-vertical-watch-card-list-renderer --><!-- Shady DOM styles for ytd-watch-card-section-sequence-renderer --><!-- Shady DOM styles for ytd-universal-watch-card-renderer --><!-- Shady DOM styles for ytd-watch-card-renderer --><!-- Shady DOM styles for ytd-video-game-watch-card-renderer --><!-- Shady DOM styles for ytd-secondary-search-container-renderer --><!-- Shady DOM styles for ytd-page-continuation --><!-- Shady DOM styles for ytd-two-column-search-results-renderer --><!-- Shady DOM styles for ytd-search --><!-- Shady DOM styles for yt-view-count-renderer --><!-- Shady DOM styles for ytd-sentiment-bar-renderer --><!-- Shady DOM styles for ytd-video-primary-info-renderer --><!-- Shady DOM styles for ytd-metadata-row-renderer --><!-- Shady DOM styles for ytd-metadata-with-image-row-renderer --><!-- Shady DOM styles for ytd-metadata-row-container-renderer --><!-- Shady DOM styles for ytd-video-owner-renderer --><!-- Shady DOM styles for ytd-video-secondary-info-renderer --><!-- Shady DOM styles for ytd-compact-playlist-renderer --><!-- Shady DOM styles for ytd-compact-promoted-video-renderer --><!-- Shady DOM styles for ytd-compact-radio-renderer --><!-- Shady DOM styles for ytd-compact-video-renderer --><!-- Shady DOM styles for ytd-compact-autoplay-renderer --><!-- Shady DOM styles for ytd-ratings --><!-- Shady DOM styles for ytd-offer-review-renderer --><!-- Shady DOM styles for ytd-movie-offer-module-renderer --><!-- Shady DOM styles for ytd-unlimited-offer-module-renderer --><!-- Shady DOM styles for ytd-watch-next-secondary-results-renderer --><!-- Shady DOM styles for ytd-companion-legal-text-renderer --><!-- Shady DOM styles for ytd-iframe-companion-renderer --><!-- Shady DOM styles for ytd-shopping-companion-item-renderer --><!-- Shady DOM styles for ytd-shopping-companion-renderer --><!-- Shady DOM styles for ytd-companion-slot-renderer --><!-- Shady DOM styles for ytd-player-legacy-desktop-watch-ads-renderer --><!-- Shady DOM styles for paper-toast --><!-- Shady DOM styles for ytd-notification-action-renderer --><!-- Shady DOM styles for ytd-video-quality-promo-renderer --><!-- Shady DOM styles for ytd-options-renderer --><!-- Shady DOM styles for ytd-report-form-details-sub-view-renderer --><!-- Shady DOM styles for ytd-report-form-extra-options-sub-view-renderer --><!-- Shady DOM styles for ytd-report-form-renderer --><!-- Shady DOM styles for ytd-video-report-action-result-renderer --><!-- Shady DOM styles for ytd-report-form-loader --><!-- Shady DOM styles for ytd-player-error-message-renderer --><!-- Shady DOM styles for ytd-player-kav-renderer --><!-- Shady DOM styles for ytd-playability-error-supported-renderers --><!-- Shady DOM styles for ytd-pla-shelf-item-renderer --><!-- Shady DOM styles for ytd-pla-shelf-renderer --><!-- Shady DOM styles for ytd-live-chat-frame --><!-- Shady DOM styles for ytd-playlist-panel-video-renderer --><!-- Shady DOM styles for iron-list --><!-- Shady DOM styles for ytd-playlist-panel-renderer --><!-- Shady DOM styles for ytd-watch --><!-- Shady DOM styles for ytd-page-manager --><!-- Shady DOM styles for yt-player-manager --><!-- Shady DOM styles for ytd-miniplayer --><!-- Shady DOM styles for paper-dialog-scrollable --><!-- Shady DOM styles for ytd-debug-menu --><!-- Shady DOM styles for ytd-searchbox --><!-- Shady DOM styles for ytd-yoodle-renderer --><!-- Shady DOM styles for ytd-topbar-logo-renderer --><!-- Shady DOM styles for ytd-topbar-menu-button-renderer --><!-- Shady DOM styles for ytd-notification-topbar-button-renderer --><!-- Shady DOM styles for ytd-consent-bump-lightbox --><!-- Shady DOM styles for ytd-consent-bump-renderer --><!-- Shady DOM styles for ytd-masthead --><!-- Shady DOM styles for ytd-polymer-gfeedback-button --><!-- Shady DOM styles for ytd-polymer-opt-out-button --><!-- Shady DOM styles for ytd-modal-with-title-and-button-renderer --><!-- Shady DOM styles for paper-checkbox --><!-- Shady DOM styles for ytd-sharing-embed-renderer --><!-- Shady DOM styles for ytd-sharing-renderer --><!-- Shady DOM styles for ytd-confirm-dialog-renderer --><!-- Shady DOM styles for ytd-account-item-renderer --><!-- Shady DOM styles for ytd-account-item-section-header-renderer --><!-- Shady DOM styles for ytd-account-item-section-renderer --><!-- Shady DOM styles for ytd-account-section-list-renderer --><!-- Shady DOM styles for ytd-active-account-header-renderer --><!-- Shady DOM styles for ytd-simple-menu-header-renderer --><!-- Shady DOM styles for ytd-background-promo-renderer --><!-- Shady DOM styles for yt-multi-page-menu-section-renderer --><!-- Shady DOM styles for ytd-multi-page-menu-renderer --><!-- Shady DOM styles for ytd-dismissal-reason-text-renderer --><!-- Shady DOM styles for ytd-dismissal-reason-video-renderer --><!-- Shady DOM styles for ytd-dismissal-follow-up-renderer --><!-- Shady DOM styles for ytd-polymer-opt-out-feedback-null-option-renderer --><!-- Shady DOM styles for ytd-polymer-opt-out-feedback-option-renderer --><!-- Shady DOM styles for ytd-polymer-opt-out-feedback-dialog-renderer --><!-- Shady DOM styles for ytd-single-option-survey-option-renderer --><!-- Shady DOM styles for ytd-single-option-survey-renderer --><!-- Shady DOM styles for ytd-survey-follow-up-renderer --><!-- Shady DOM styles for ytd-report-form-modal-renderer --><!-- Shady DOM styles for ytd-text-input-form-field-renderer --><!-- Shady DOM styles for ytd-form-renderer --><!-- Shady DOM styles for ytd-form-popup-renderer --><!-- Shady DOM styles for ytd-menu-navigation-item-renderer --><!-- Shady DOM styles for ytd-menu-service-item-renderer --><!-- Shady DOM styles for ytd-toggle-menu-service-item-renderer --><!-- Shady DOM styles for ytd-menu-popup-renderer --><!-- Shady DOM styles for ytd-add-to-playlist-create-renderer --><!-- Shady DOM styles for ytd-playlist-add-to-option-renderer --><!-- Shady DOM styles for ytd-add-to-playlist-renderer --><!-- Shady DOM styles for ytd-unlimited-family-message-interstitial-renderer --><!-- Shady DOM styles for ytd-unlimited-family-profile-interstitial-renderer --><!-- Shady DOM styles for ytd-popup-container --><!-- Shady DOM styles for ytd-guide-entry-renderer --><!-- Shady DOM styles for ytd-guide-collapsible-entry-renderer --><!-- Shady DOM styles for ytd-guide-section-renderer --><!-- Shady DOM styles for ytd-guide-signin-promo-renderer --><!-- Shady DOM styles for ytd-guide-subscriptions-section-renderer --><!-- Shady DOM styles for ytd-guide-renderer --><!-- Shady DOM styles for yt-history-manager --><!-- Shady DOM styles for yt-navigation-manager --><!-- Shady DOM styles for yt-network-manager --><!-- Shady DOM styles for iron-signals --><!-- Shady DOM styles for yt-visibility-monitor --><!-- Shady DOM styles for yt-activity-manager --><!-- Shady DOM styles for yt-auth-manager --><!-- Shady DOM styles for yt-gfeedback-manager --><!-- Shady DOM styles for yt-mdx-manager --><!-- Shady DOM styles for yt-playlist-manager --><!-- Shady DOM styles for yt-spacecast-manager --><!-- Shady DOM styles for yt-page-navigation-progress --><!-- Shady DOM styles for yt-create-family-dialog --><!-- Shady DOM styles for ytd-app -->In this video we show you how to take a 445 Calendar summarized table and turn it into a table you can use in PowerBI DAX formulas.</P><P>&nbsp;</P><P>So if you've got a calendar table that has one row per period not per day, and has the period's start and end dates, this video will show you how to get that into a one row per date table that you can use in PowerBI for DAX calculation.</P><P>&nbsp;</P><DIV class="style-scope ytd-app">&nbsp;</DIV><P>&nbsp;</P><P><SPAN class="videoUrl hidden">watch?v=GSdImSb3MLw</SPAN></P> Thu, 30 Mar 2017 17:10:10 GMT BrianGrant 2017-03-30T17:10:10Z https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Turning-445-Calendar-Summary-Table-to-Usable-Table/m-p/151548#M19 <P><!-- Shady DOM styles for custom-style --><!-- Shady DOM styles for dom-template --><!-- Shady DOM styles for dom-repeat --><!-- Shady DOM styles for array-selector --><!-- Shady DOM styles for dom-if --><!-- Shady DOM styles for app-box --><!-- Shady DOM styles for app-drawer --><!-- Shady DOM styles for iron-media-query --><!-- Shady DOM styles for app-drawer-layout --><!-- Shady DOM styles for app-header-layout --><!-- Shady DOM styles for app-header --><!-- Shady DOM styles for app-scrollpos-control --><!-- Shady DOM styles for app-toolbar --><!-- Shady DOM styles for yt-guide-manager --><!-- Shady DOM styles for iron-meta --><!-- Shady DOM styles for iron-meta-query --><!-- Shady DOM styles for iron-icon --><!-- Shady DOM styles for paper-ripple --><!-- Shady DOM styles for paper-icon-button --><!-- Shady DOM styles for paper-icon-button-light --><!-- Shady DOM styles for paper-icon-item --><!-- Shady DOM styles for paper-item-body --><!-- Shady DOM styles for paper-item --><!-- Shady DOM styles for paper-toggle-button --><!-- Shady DOM styles for iron-iconset-svg --><!-- Shady DOM styles for yt-icon --><!-- Shady DOM styles for ytd-account-settings --><!-- Shady DOM styles for ytd-channel-custom-gadget-renderer --><!-- Shady DOM styles for paper-material --><!-- Shady DOM styles for paper-button --><!-- Shady DOM styles for yt-endpoint --><!-- Shady DOM styles for yt-formatted-string --><!-- Shady DOM styles for ytd-expander --><!-- Shady DOM styles for fade-in-animation --><!-- Shady DOM styles for fade-out-animation --><!-- Shady DOM styles for opaque-animation --><!-- Shady DOM styles for paper-tooltip --><!-- Shady DOM styles for ytd-badge-supported-renderer --><!-- Shady DOM styles for ytd-video-meta-block --><!-- Shady DOM styles for ytd-channel-video-player-renderer --><!-- Shady DOM styles for ytd-comment-history-block-header-renderer --><!-- Shady DOM styles for yt-img-shadow --><!-- Shady DOM styles for ytd-backstage-image-renderer --><!-- Shady DOM styles for ytd-button-renderer --><!-- Shady DOM styles for ytd-toggle-button-renderer --><!-- Shady DOM styles for ytd-menu-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-hover-text-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-playback-status-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-resume-playback-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-side-panel-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-time-status-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-toggle-button-renderer --><!-- Shady DOM styles for ytd-thumbnail --><!-- Shady DOM styles for ytd-notification-text-renderer --><!-- Shady DOM styles for ytd-video-renderer --><!-- Shady DOM styles for ytd-comment-history-entry-renderer --><!-- Shady DOM styles for ytd-author-comment-badge-renderer --><!-- Shady DOM styles for iron-autogrow-textarea --><!-- Shady DOM styles for paper-input-char-counter --><!-- Shady DOM styles for paper-input-container --><!-- Shady DOM styles for paper-input-error --><!-- Shady DOM styles for iron-a11y-announcer --><!-- Shady DOM styles for iron-input --><!-- Shady DOM styles for paper-input --><!-- Shady DOM styles for paper-textarea --><!-- Shady DOM styles for paper-spinner --><!-- Shady DOM styles for paper-spinner-lite --><!-- Shady DOM styles for ytd-backstage-image-select-renderer --><!-- Shady DOM styles for ytd-commentbox --><!-- Shady DOM styles for ytd-comment-reply-dialog-renderer --><!-- Shady DOM styles for ytd-creator-heart-renderer --><!-- Shady DOM styles for ytd-comment-action-buttons-renderer --><!-- Shady DOM styles for ytd-comment-dialog-renderer --><!-- Shady DOM styles for ytd-pinned-comment-badge-renderer --><!-- Shady DOM styles for ytd-comment-renderer --><!-- Shady DOM styles for yt-next-continuation --><!-- Shady DOM styles for ytd-comment-replies-renderer --><!-- Shady DOM styles for ytd-comment-thread-renderer --><!-- Shady DOM styles for ytd-notification-renderer --><!-- Shady DOM styles for iron-collapse --><!-- Shady DOM styles for ytd-generic-faq-question-renderer --><!-- Shady DOM styles for ytd-faq-section-renderer --><!-- Shady DOM styles for ytd-purchase-item-renderer --><!-- Shady DOM styles for ytd-simple-text-section-renderer --><!-- Shady DOM styles for iron-image --><!-- Shady DOM styles for paper-card --><!-- Shady DOM styles for ytd-unlimited-manage-subscription-page-renderer --><!-- Shady DOM styles for ytd-unlimited-page-feature-info-renderer --><!-- Shady DOM styles for ytd-single-ypc-offer-renderer --><!-- Shady DOM styles for ytd-collapsible-ypc-offer-renderer --><!-- Shady DOM styles for iron-overlay-backdrop --><!-- Shady DOM styles for paper-dialog --><!-- Shady DOM styles for ytd-unlimited-page-header-renderer --><!-- Shady DOM styles for ytd-single-ypc-offer-list-renderer --><!-- Shady DOM styles for ytd-ypc-offers-list-renderer --><!-- Shady DOM styles for ytd-channel-about-metadata-renderer --><!-- Shady DOM styles for ytd-subscribe-button-renderer --><!-- Shady DOM styles for ytd-channel-renderer --><!-- Shady DOM styles for ytd-child-video-renderer --><!-- Shady DOM styles for ytd-playlist-custom-thumbnail-renderer --><!-- Shady DOM styles for ytd-playlist-video-thumbnail-renderer --><!-- Shady DOM styles for ytd-show-custom-thumbnail-renderer --><!-- Shady DOM styles for ytd-thumbnail-overlay-bottom-panel-renderer --><!-- Shady DOM styles for ytd-playlist-thumbnail --><!-- Shady DOM styles for ytd-playlist-renderer --><!-- Shady DOM styles for ytd-radio-renderer --><!-- Shady DOM styles for ytd-show-renderer --><!-- Shady DOM styles for ytd-channel-featured-content-renderer --><!-- Shady DOM styles for ytd-compact-link-renderer --><!-- Shady DOM styles for ytd-crisis-health-renderer --><!-- Shady DOM styles for ytd-single-action-emergency-support-renderer --><!-- Shady DOM styles for ytd-emergency-onebox-renderer --><!-- Shady DOM styles for ytd-exploratory-results-renderer --><!-- Shady DOM styles for ytd-feed-entry-renderer --><!-- Shady DOM styles for ytd-message-renderer --><!-- Shady DOM styles for paper-radio-button --><!-- Shady DOM styles for paper-radio-group --><!-- Shady DOM styles for ytd-feedback-elicitation-single-question-renderer --><!-- Shady DOM styles for ytd-grid-channel-renderer --><!-- Shady DOM styles for ytd-grid-movie-playlist-renderer --><!-- Shady DOM styles for ytd-grid-playlist-renderer --><!-- Shady DOM styles for ytd-grid-show-renderer --><!-- Shady DOM styles for ytd-notification-multi-action-renderer --><!-- Shady DOM styles for ytd-standalone-ypc-badge-renderer --><!-- Shady DOM styles for ytd-standalone-badge-supported-renderer --><!-- Shady DOM styles for ytd-grid-video-renderer --><!-- Shady DOM styles for ytd-music-pass-small-feature-info-renderer --><!-- Shady DOM styles for ytd-grid-renderer --><!-- Shady DOM styles for ytd-music-pass-feature-info-renderer --><!-- Shady DOM styles for ytd-newspaper-hero-video-renderer --><!-- Shady DOM styles for ytd-newspaper-mini-video-renderer --><!-- Shady DOM styles for ytd-newspaper-renderer --><!-- Shady DOM styles for ytd-playlist-video-renderer --><!-- Shady DOM styles for ytd-playlist-video-list-renderer --><!-- Shady DOM styles for ytd-search-history-query-renderer --><!-- Shady DOM styles for ytd-search-no-results-renderer --><!-- Shady DOM styles for ytd-promoted-video-renderer --><!-- Shady DOM styles for ytd-search-pyv-renderer --><!-- Shady DOM styles for ytd-compact-promoted-item-renderer --><!-- Shady DOM styles for ytd-expanded-shelf-contents-renderer --><!-- Shady DOM styles for ytd-grid-movie-renderer --><!-- Shady DOM styles for ytd-grid-radio-renderer --><!-- Shady DOM styles for yt-horizontal-list-renderer --><!-- Shady DOM styles for ytd-vertical-list-renderer --><!-- Shady DOM styles for ytd-shelf-renderer --><!-- Shady DOM styles for yt-search-query-correction --><!-- Shady DOM styles for yt-did-you-mean-renderer --><!-- Shady DOM styles for yt-including-results-for-renderer --><!-- Shady DOM styles for yt-no-results-found-showing-results-for-renderer --><!-- Shady DOM styles for yt-results-without-quotes-renderer --><!-- Shady DOM styles for yt-showing-results-for-renderer --><!-- Shady DOM styles for yt-masthead-ad-renderer --><!-- Shady DOM styles for ytd-video-masthead-ad-renderer --><!-- Shady DOM styles for ytd-alert-renderer --><!-- Shady DOM styles for ytd-channel-legal-info-renderer --><!-- Shady DOM styles for paper-tab --><!-- Shady DOM styles for paper-tabs --><!-- Shady DOM styles for ytd-channel-avatar-editor --><!-- Shady DOM styles for ytd-expandable-tab-renderer --><!-- Shady DOM styles for ytd-c4-tabbed-header-renderer --><!-- Shady DOM styles for ytd-playlist-sidebar-renderer --><!-- Shady DOM styles for ytd-navigation-dropdown-item-renderer --><!-- Shady DOM styles for ytd-privacy-dropdown-item-renderer --><!-- Shady DOM styles for paper-menu-grow-height-animation --><!-- Shady DOM styles for paper-menu-grow-width-animation --><!-- Shady DOM styles for paper-menu-shrink-width-animation --><!-- Shady DOM styles for paper-menu-shrink-height-animation --><!-- Shady DOM styles for iron-dropdown --><!-- Shady DOM styles for paper-menu-button --><!-- Shady DOM styles for paper-dropdown-menu --><!-- Shady DOM styles for paper-dropdown-menu-light --><!-- Shady DOM styles for paper-listbox --><!-- Shady DOM styles for ytd-dropdown-renderer --><!-- Shady DOM styles for ytd-playlist-header-renderer --><!-- Shady DOM styles for ytd-survey-trigger-renderer --><!-- Shady DOM styles for ytd-banner-promo-renderer --><!-- Shady DOM styles for ytd-channel-metadata-renderer --><!-- Shady DOM styles for ytd-sub-feed-option-renderer --><!-- Shady DOM styles for ytd-sub-feed-selector-renderer --><!-- Shady DOM styles for ytd-browse-feed-actions-renderer --><!-- Shady DOM styles for paper-menu --><!-- Shady DOM styles for paper-submenu --><!-- Shady DOM styles for yt-reload-continuation --><!-- Shady DOM styles for yt-supported-renderers --><!-- Shady DOM styles for yt-dropdown-menu --><!-- Shady DOM styles for ytd-sort-filter-sub-menu-renderer --><!-- Shady DOM styles for ytd-channel-sub-menu-renderer --><!-- Shady DOM styles for ytd-backstage-post-dialog-renderer --><!-- Shady DOM styles for ytd-comment-simplebox-renderer --><!-- Shady DOM styles for ytd-comments-header-renderer --><!-- Shady DOM styles for ytd-item-section-renderer --><!-- Shady DOM styles for ytd-search-filter-renderer --><!-- Shady DOM styles for ytd-search-filter-group-renderer --><!-- Shady DOM styles for ytd-search-sub-menu-renderer --><!-- Shady DOM styles for ytd-comments --><!-- Shady DOM styles for ytd-channel-age-gate-renderer --><!-- Shady DOM styles for ytd-section-list-renderer --><!-- Shady DOM styles for yt-app-context --><!-- Shady DOM styles for yt-service --><!-- Shady DOM styles for ytd-two-column-browse-results-renderer --><!-- Shady DOM styles for ytd-browse --><!-- Shady DOM styles for iron-pages --><!-- Shady DOM styles for ytd-watch-card-album-list-renderer --><!-- Shady DOM styles for ytd-watch-card-collage-renderer --><!-- Shady DOM styles for ytd-watch-card-single-image-renderer --><!-- Shady DOM styles for ytd-watch-card-video-list-renderer --><!-- Shady DOM styles for ytd-generic-watch-card --><!-- Shady DOM styles for ytd-artist-watch-card-renderer --><!-- Shady DOM styles for ytd-show-watch-card-renderer --><!-- Shady DOM styles for ytd-watch-card-hero-video-renderer --><!-- Shady DOM styles for ytd-watch-card-rich-header-renderer --><!-- Shady DOM styles for ytd-watch-card-compact-video-renderer --><!-- Shady DOM styles for ytd-vertical-watch-card-list-renderer --><!-- Shady DOM styles for ytd-watch-card-section-sequence-renderer --><!-- Shady DOM styles for ytd-universal-watch-card-renderer --><!-- Shady DOM styles for ytd-watch-card-renderer --><!-- Shady DOM styles for ytd-video-game-watch-card-renderer --><!-- Shady DOM styles for ytd-secondary-search-container-renderer --><!-- Shady DOM styles for ytd-page-continuation --><!-- Shady DOM styles for ytd-two-column-search-results-renderer --><!-- Shady DOM styles for ytd-search --><!-- Shady DOM styles for yt-view-count-renderer --><!-- Shady DOM styles for ytd-sentiment-bar-renderer --><!-- Shady DOM styles for ytd-video-primary-info-renderer --><!-- Shady DOM styles for ytd-metadata-row-renderer --><!-- Shady DOM styles for ytd-metadata-with-image-row-renderer --><!-- Shady DOM styles for ytd-metadata-row-container-renderer --><!-- Shady DOM styles for ytd-video-owner-renderer --><!-- Shady DOM styles for ytd-video-secondary-info-renderer --><!-- Shady DOM styles for ytd-compact-playlist-renderer --><!-- Shady DOM styles for ytd-compact-promoted-video-renderer --><!-- Shady DOM styles for ytd-compact-radio-renderer --><!-- Shady DOM styles for ytd-compact-video-renderer --><!-- Shady DOM styles for ytd-compact-autoplay-renderer --><!-- Shady DOM styles for ytd-ratings --><!-- Shady DOM styles for ytd-offer-review-renderer --><!-- Shady DOM styles for ytd-movie-offer-module-renderer --><!-- Shady DOM styles for ytd-unlimited-offer-module-renderer --><!-- Shady DOM styles for ytd-watch-next-secondary-results-renderer --><!-- Shady DOM styles for ytd-companion-legal-text-renderer --><!-- Shady DOM styles for ytd-iframe-companion-renderer --><!-- Shady DOM styles for ytd-shopping-companion-item-renderer --><!-- Shady DOM styles for ytd-shopping-companion-renderer --><!-- Shady DOM styles for ytd-companion-slot-renderer --><!-- Shady DOM styles for ytd-player-legacy-desktop-watch-ads-renderer --><!-- Shady DOM styles for paper-toast --><!-- Shady DOM styles for ytd-notification-action-renderer --><!-- Shady DOM styles for ytd-video-quality-promo-renderer --><!-- Shady DOM styles for ytd-options-renderer --><!-- Shady DOM styles for ytd-report-form-details-sub-view-renderer --><!-- Shady DOM styles for ytd-report-form-extra-options-sub-view-renderer --><!-- Shady DOM styles for ytd-report-form-renderer --><!-- Shady DOM styles for ytd-video-report-action-result-renderer --><!-- Shady DOM styles for ytd-report-form-loader --><!-- Shady DOM styles for ytd-player-error-message-renderer --><!-- Shady DOM styles for ytd-player-kav-renderer --><!-- Shady DOM styles for ytd-playability-error-supported-renderers --><!-- Shady DOM styles for ytd-pla-shelf-item-renderer --><!-- Shady DOM styles for ytd-pla-shelf-renderer --><!-- Shady DOM styles for ytd-live-chat-frame --><!-- Shady DOM styles for ytd-playlist-panel-video-renderer --><!-- Shady DOM styles for iron-list --><!-- Shady DOM styles for ytd-playlist-panel-renderer --><!-- Shady DOM styles for ytd-watch --><!-- Shady DOM styles for ytd-page-manager --><!-- Shady DOM styles for yt-player-manager --><!-- Shady DOM styles for ytd-miniplayer --><!-- Shady DOM styles for paper-dialog-scrollable --><!-- Shady DOM styles for ytd-debug-menu --><!-- Shady DOM styles for ytd-searchbox --><!-- Shady DOM styles for ytd-yoodle-renderer --><!-- Shady DOM styles for ytd-topbar-logo-renderer --><!-- Shady DOM styles for ytd-topbar-menu-button-renderer --><!-- Shady DOM styles for ytd-notification-topbar-button-renderer --><!-- Shady DOM styles for ytd-consent-bump-lightbox --><!-- Shady DOM styles for ytd-consent-bump-renderer --><!-- Shady DOM styles for ytd-masthead --><!-- Shady DOM styles for ytd-polymer-gfeedback-button --><!-- Shady DOM styles for ytd-polymer-opt-out-button --><!-- Shady DOM styles for ytd-modal-with-title-and-button-renderer --><!-- Shady DOM styles for paper-checkbox --><!-- Shady DOM styles for ytd-sharing-embed-renderer --><!-- Shady DOM styles for ytd-sharing-renderer --><!-- Shady DOM styles for ytd-confirm-dialog-renderer --><!-- Shady DOM styles for ytd-account-item-renderer --><!-- Shady DOM styles for ytd-account-item-section-header-renderer --><!-- Shady DOM styles for ytd-account-item-section-renderer --><!-- Shady DOM styles for ytd-account-section-list-renderer --><!-- Shady DOM styles for ytd-active-account-header-renderer --><!-- Shady DOM styles for ytd-simple-menu-header-renderer --><!-- Shady DOM styles for ytd-background-promo-renderer --><!-- Shady DOM styles for yt-multi-page-menu-section-renderer --><!-- Shady DOM styles for ytd-multi-page-menu-renderer --><!-- Shady DOM styles for ytd-dismissal-reason-text-renderer --><!-- Shady DOM styles for ytd-dismissal-reason-video-renderer --><!-- Shady DOM styles for ytd-dismissal-follow-up-renderer --><!-- Shady DOM styles for ytd-polymer-opt-out-feedback-null-option-renderer --><!-- Shady DOM styles for ytd-polymer-opt-out-feedback-option-renderer --><!-- Shady DOM styles for ytd-polymer-opt-out-feedback-dialog-renderer --><!-- Shady DOM styles for ytd-single-option-survey-option-renderer --><!-- Shady DOM styles for ytd-single-option-survey-renderer --><!-- Shady DOM styles for ytd-survey-follow-up-renderer --><!-- Shady DOM styles for ytd-report-form-modal-renderer --><!-- Shady DOM styles for ytd-text-input-form-field-renderer --><!-- Shady DOM styles for ytd-form-renderer --><!-- Shady DOM styles for ytd-form-popup-renderer --><!-- Shady DOM styles for ytd-menu-navigation-item-renderer --><!-- Shady DOM styles for ytd-menu-service-item-renderer --><!-- Shady DOM styles for ytd-toggle-menu-service-item-renderer --><!-- Shady DOM styles for ytd-menu-popup-renderer --><!-- Shady DOM styles for ytd-add-to-playlist-create-renderer --><!-- Shady DOM styles for ytd-playlist-add-to-option-renderer --><!-- Shady DOM styles for ytd-add-to-playlist-renderer --><!-- Shady DOM styles for ytd-unlimited-family-message-interstitial-renderer --><!-- Shady DOM styles for ytd-unlimited-family-profile-interstitial-renderer --><!-- Shady DOM styles for ytd-popup-container --><!-- Shady DOM styles for ytd-guide-entry-renderer --><!-- Shady DOM styles for ytd-guide-collapsible-entry-renderer --><!-- Shady DOM styles for ytd-guide-section-renderer --><!-- Shady DOM styles for ytd-guide-signin-promo-renderer --><!-- Shady DOM styles for ytd-guide-subscriptions-section-renderer --><!-- Shady DOM styles for ytd-guide-renderer --><!-- Shady DOM styles for yt-history-manager --><!-- Shady DOM styles for yt-navigation-manager --><!-- Shady DOM styles for yt-network-manager --><!-- Shady DOM styles for iron-signals --><!-- Shady DOM styles for yt-visibility-monitor --><!-- Shady DOM styles for yt-activity-manager --><!-- Shady DOM styles for yt-auth-manager --><!-- Shady DOM styles for yt-gfeedback-manager --><!-- Shady DOM styles for yt-mdx-manager --><!-- Shady DOM styles for yt-playlist-manager --><!-- Shady DOM styles for yt-spacecast-manager --><!-- Shady DOM styles for yt-page-navigation-progress --><!-- Shady DOM styles for yt-create-family-dialog --><!-- Shady DOM styles for ytd-app -->In this video we show you how to take a 445 Calendar summarized table and turn it into a table you can use in PowerBI DAX formulas.</P><P>&nbsp;</P><P>So if you've got a calendar table that has one row per period not per day, and has the period's start and end dates, this video will show you how to get that into a one row per date table that you can use in PowerBI for DAX calculation.</P><P>&nbsp;</P><DIV class="style-scope ytd-app">&nbsp;</DIV><P>&nbsp;</P><P><SPAN class="videoUrl hidden">watch?v=GSdImSb3MLw</SPAN></P> Thu, 30 Mar 2017 17:10:10 GMT https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Turning-445-Calendar-Summary-Table-to-Usable-Table/m-p/151548#M19 BrianGrant 2017-03-30T17:10:10Z