Have you ever wondered why Power BI report developers need to create their own date table EVERY SINGLE time they create a report?
Well, the short answer is they DON'T!
You can streamline the process by creating a parameterized, M code-based Date Table in Power Query and it will be super flexible, so others within the organization can fine-tune to their likings.
It is especially true when an organization follows a different financial calendar or a special, like 4-5-4 week calendar. A more senior developer can create the dates themselves and all the other columns to use in reporting.
This step will ensure consistency across all reports and guarantees that all the time intelligence calculations will work fine.
If you want to learn how to do all of that, watch this video!
Have a good one,
Roland
💪 New videos coming every Tuesday 🤹‍♂‍
🤘 New short videos coming every week 👨‍🏫
📝 BLOG POST: bilingualanalytics.com.au/cal...
🎬 MORE VIDEOS:
How To Group Field Parameters in Power BI Using DAX - Enhance Report UI - • How To Group Field Par...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Secu...
How To Group Field Parameters in Power BI Using DAX - Enhance Report UI - • Implement RLS On Power...
Chapters:
00:00 Topic Of The Day - Flexible Centralised Date Table
00:23 Intro
00:35 BI-Lingual Analytics
00:54 Flexible Calendars in Power BI
01:38 Power Query Based Calendar Table with Parameters
02:40 Additional Date Fields
03:26 Export Power BI Template
03:53 Template Files' Benefits
04:13 How To Use Template Files
05:21 Streamline Date Tables
05:53 Question Of The Day
06:10 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: bilingualanalytics.com.au/abo...
📍 - Sydney, Australia
📽 GEAR:
📷 - Sony ZV-E10
🎙 - Audio Technica AT2020
🔦 - Neewer 18” Ring Light, Elgato Key Light
🎧 - BOSE QC35
🖥 - ASUS VC279H + Xiaomi Mi Curved 34"
💻 - Intel i7-12700K, Gigabyte Aorus Master 3080 12GB, Corsair Vengeance LPX 64GB, Samsung 980Pro 1TB
Music: www.bensound.com
#PowerBI #PowerQuery #BILingualAnalytics