Uploaded March 2025 | Updated November 2026, 2 days ago
Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items.
Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas.
GUEST BIO (Chris Barber)👤
Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI.
RELATED CONTENT 🔗
PBIX Download - starschema.co.uk/downloads
Website -- starschema.co.uk
Linkedin -- linkedin.com/in/christophermichaelbarber
VIDEO CHAPTERS 📺
0:00 - Video Start
5:00 - Start of Livestream
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=mWSqcx81Cc8
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizations #finance #fpna #pnl #financialreporting #financialstatements
Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items.
Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas.
GUEST BIO (Chris Barber)👤
Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI.
RELATED CONTENT 🔗
PBIX Download - starschema.co.uk/downloads
Website -- starschema.co.uk
Linkedin -- linkedin.com/in/christophermichaelbarber
VIDEO CHAPTERS 📺
0:00 - Video Start
5:00 - Start of Livestream
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=mWSqcx81Cc8
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=mWSqcx81Cc8
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizations #finance #fpna #pnl #financialreporting #financialstatements









![Visual Calculations – Making [DAX] Easier (with Jeroen ter Heerdt)
This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature!
Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.
GUEST BIO (Jeroen ter Heerdt) 👤
Jeroen ter Heerdt is a Product Manager with Microsoft. He works on Power BI and is passionate about all things data; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, advanced analytics, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision, and hands-on experience into his talks.
RELATED CONTENT 🔗
Blog http://www.dutchdatadude.com
LinkedIn https://www.linkedin.com/in/jeroenterheerdt
Understanding Visual Calculations https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave2/power-bi/visual-calculations
VIDEO CHAPTERS 📺
0:00 - Video Start
5:00 - Start of Live stream
LETS CONNECT! 🧑🏽🤝🧑🏽🌟
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE 👕
https://havens-consulting.creator-spring.com/
HAVENS CONSULTING PAGES 📄
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #visualcalcs #visualcalculations #reporting Visual Calculations – Making [DAX] Easier (with Jeroen ter Heerdt)](https://i.ytimg.com/vi/pV_OgvL4XqY/mqdefault.jpg)
