Posts tagged #Matrix Tables

(Livestream Replay) Building Income Statements in Power BI - with Chris Barber

DESCRIPTION 📄

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 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 🔗

Website
Linkedin

Creating [DAX] SVG Charts using Chat GPT!

Video by: Reid Havens

Learn how to leverage the POWER of Chat GPT to generate any SVG chart you can imagine, as a [DAX] measure for tables and matrix native visuals in Power BI Desktop. Tune in to learn more!

RELATED CONTENT 🔗

Brian Julius’s LinkedIn Post
Creating a Range Bar from a Native Visual

Posted on November 19, 2024 and filed under Visualizations, DAX, Chat GPT.

Creating a Calendar Slicer from a Matrix Table! (with Erik Svensen)

Video by: Reid Havens

Join Erik Svensen and I as Erik walks through how to transform a native matrix visual into a powerful Calendar type filter for your visuals! Where you can slice by date, day of week, week period of year, and more. Tune in for the demo!

GUEST BIO (Erik Svensen)👤

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

Erik's Blog
Erik's LinkedIn
CatMan Solutions