How to Do a YTD Calculation in Power BI
Vložit
- čas přidán 5. 09. 2024
- 📧 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 - goodly.wordpress@gmail.com
===== 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!
📌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/
short and simple, thank you sharing
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. 😉😉
Why ww not use date in sales table? It's same with date in table calendar right?
Some companies might put Fiscal date in the calendar table for easy conversion.
Thank You🙏
Good video. But i personally prefer lengthy video of yours.
Could you please do a video where the financial year starts on 1 March (and how to deal with leap years)
When will you start the online lecture? For power query
They're on youtube already.
This has been made simpler with the new visual calculation. You didn't include that
First viewer