How to Do a YTD Calculation in Power BI

📧 Subscribe to my Email Newsletter - goodly.co.in/s...
• Clever Date Table Tric...
• Fiscal Year Date Table...
In this quick tutorial, we will learn how to perform a Year-to-Date (YTD) calculation in Power BI. You will learn the step-by-step process of setting up a simple matrix or pivot table, utilizing various formulas within Power BI and understanding the concept of the spillover effect while calculating the YTD. Additionally, I will address the calculation of YTD within a financial year context, demonstrating tweaks to the data model and formulas.
#PowerBI #YTDCalculation #Dataanalysts
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/l...
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step-by-Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

[@GoodlyChandeep]

📌Recommended Videos📌
Clever Date Table Trick in Power BI you've got to learn! - czcams.com/video/ztJhqLOMzGY/video.htmlsi=zbv-VAx_9y_-XHgg
Fiscal Year Date Table in Power BI - czcams.com/video/ef-KmCB-qXY/video.htmlsi=ZaAlPA7mqZHj786o czcams.com/video/ef-KmCB-qXY/video.htmlsi=ZaAlPA7mqZHj786o
📧Subscribe to my Email Newsletter - goodly.co.in/subscribe/
Also, check out my courses on DAX & Data Modeling 📊 - goodly.co.in/learn-dax-powerbi/

[@unnikrishnansanthosh]

short and simple, thank you sharing

[@williamarthur4801]

Hi, Chandeep, don't know if you'll see this but if so, what was the title of the video you released
what you use an addcolum and try _ , so you could get a column telling the errors,
I could to do re watch it. 😉😉

[@SaxonChuang]

Why ww not use date in sales table? It's same with date in table calendar right?

[@Crisis742]

Some companies might put Fiscal date in the calendar table for easy conversion.

[@dilipinamdar5523]

Thank You🙏

[@OneNI83]

Good video. But i personally prefer lengthy video of yours.

[@hendriklwanga-iga6817]

Could you please do a video where the financial year starts on 1 March (and how to deal with leap years)

[@dipeshnikalje]

When will you start the online lecture? For power query

[@pieterlinden8292]

They're on youtube already.

[@ebenasare8661]

This has been made simpler with the new visual calculation. You didn't include that

[@dipeshnikalje]

First viewer