Uploaded August 2023 | Updated November 2026, 1 day ago
Learning how to solve advanced problems using the M language which are beyond the scope of Power Query User Interface. Discover the beauty of the mash-up (m) language, additional functions that you can't find using just the U/I, learn about parameters and query types, and more. Tune in to find out!
GUEST BIO ๐ค
Chandeep Chhabra works with clients around the world on training and consulting projects on Excel and Power BI. Prior to starting Goodly (his venture), he worked as a Financial Analyst for an Investment Bank in Mumbai, India. Follow and connect with Chandeep online:
RELATED CONTENT ๐
Blog - goodly.co.in/blog
YouTube - youtube.com/goodlychandeep
LinkedIn - linkedin.com/in/chandeepchhabra
Twitter - twitter.com/chandeep2786
VIDEO CHAPTERS ๐บ
0:00 - Video Start
5:00 - Start of Livestream
RELATED CONTENT ๐
LinkedIn -- linkedin.com/in/powerbisteve
Blogs -- https://powerbi.tips/author/steve-campbell/
User Group -- linkedin.com/groups/13898188
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES ๐
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #powerquerym
Learning how to solve advanced problems using the M language which are beyond the scope of Power Query User Interface. Discover the beauty of the mash-up (m) language, additional functions that you can't find using just the U/I, learn about parameters and query types, and more. Tune in to find out!
GUEST BIO ๐ค
Chandeep Chhabra works with clients around the world on training and consulting projects on Excel and Power BI. Prior to starting Goodly (his venture), he worked as a Financial Analyst for an Investment Bank in Mumbai, India. Follow and connect with Chandeep online:
RELATED CONTENT ๐
Blog - goodly.co.in/blog
YouTube - youtube.com/goodlychandeep
LinkedIn - linkedin.com/in/chandeepchhabra
Twitter - twitter.com/chandeep2786
VIDEO CHAPTERS ๐บ
0:00 - Video Start
5:00 - Start of Livestream
RELATED CONTENT ๐
LinkedIn -- linkedin.com/in/powerbisteve
Blogs -- https://powerbi.tips/author/steve-campbell/
User Group -- linkedin.com/groups/13898188
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES ๐
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=PEGF8JFimZg
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #powerquerym

![Power BI Calendar Overhaul: Calendar-Based Time Intelligence (with Jeroen [Jay] ter Heerdt)
Product Manager Jeroen ter Heerdt demos Power BIโs new calendar-based time intelligence (Preview) โ the long-overdue toolbox for anyone whoโs ever cursed at week calculations, fiscal oddities, or retail 4-4-5 madness. Heโll show how to enable the preview and use the Calendar options UI or the TMDL model view to declare calendars so DAX finally behaves the way your business calendar actually does.
Expect live demos of week-aware DAX, examples mapping fiscal/retail/ISO calendars, tips on validating calendars (cardinality, partial vs complete categories), and notes on when this can improve performance versus classic time intelligence. This session is practical, so follow along with the preview enabled and bring your weird calendar.
GUEST BIO (Jeroen [Jay] ter Heerdt) ๐ค
Dutch Data Dude. Product Manager at Microsoft.
Jeroen (Jay) ter Heerdt is a Product Manager at Microsoft. He works on Power BI and is passionate about all things data; his current focus is on DAX and modeling topics. He strives to be a โdatanerdโ in all aspects of his life. Jeroen combines enthusiasm, vision, and hands-on experience into his talks. He is on most social media as @jaypowerbi.
RELATED CONTENT ๐
Calendar-based time intelligence https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-time-intelligence#calendar-based-time-intelligence-preview
Blog Announcement https://powerbi.microsoft.com/blog/calendar-based-time-intelligence-time-intelligence-tailored-preview/
Introducing calendar-based time intelligence in DAX https://www.sqlbi.com/articles/introducing-calendar-based-time-intelligence-in-dax/
DAX AMA (Reddit) https://www.reddit.com/r/PowerBI/comments/1oif716/hi_were_the_power_bi_dax_team_ask_us_anything/
LETS CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ ๐
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
HAVENS CONSULTING PAGES ๐
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=QhTqM7WIlbM
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=QhTqM7WIlbM
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=QhTqM7WIlbM
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=QhTqM7WIlbM
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=QhTqM7WIlbM
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=QhTqM7WIlbM
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=QhTqM7WIlbM
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #DataViz #DAX #PowerPlatform #BusinessIntelligence Power BI Calendar Overhaul: Calendar-Based Time Intelligence (with Jeroen [Jay] ter Heerdt)](https://i.ytimg.com/vi/QhTqM7WIlbM/mqdefault.jpg)








