Тёмный

How to Do a YTD Calculation in Power BI 

Goodly
Подписаться 90 тыс.
Просмотров 6 тыс.
50% 1

📧 Subscribe to my Email Newsletter - goodly.co.in/subscribe/
• 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/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step-by-Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== 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!

Наука

Опубликовано:

 

5 май 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@GoodlyChandeep
@GoodlyChandeep 2 месяца назад
📌Recommended Videos📌 Clever Date Table Trick in Power BI you've got to learn! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ztJhqLOMzGY.htmlsi=zbv-VAx_9y_-XHgg Fiscal Year Date Table in Power BI - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ef-KmCB-qXY.htmlsi=ZaAlPA7mqZHj786o ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ef-KmCB-qXY.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
@unnikrishnansanthosh 2 месяца назад
short and simple, thank you sharing
@dilipinamdar5523
@dilipinamdar5523 Месяц назад
Thank You🙏
@williamarthur4801
@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. 😉😉
@MrSaxonC.
@MrSaxonC. Месяц назад
Why ww not use date in sales table? It's same with date in table calendar right?
@Crisis742
@Crisis742 29 дней назад
Some companies might put Fiscal date in the calendar table for easy conversion.
@OneNI83
@OneNI83 2 месяца назад
Good video. But i personally prefer lengthy video of yours.
@hendriklwanga-iga6817
@hendriklwanga-iga6817 2 месяца назад
Could you please do a video where the financial year starts on 1 March (and how to deal with leap years)
@dipeshnikalje
@dipeshnikalje 2 месяца назад
When will you start the online lecture? For power query
@pieterlinden8292
@pieterlinden8292 2 месяца назад
They're on youtube already.
@dipeshnikalje
@dipeshnikalje 2 месяца назад
First viewer
@ebenasare8661
@ebenasare8661 2 месяца назад
This has been made simpler with the new visual calculation. You didn't include that
Далее
Кто понял тот понял
00:24
Просмотров 325 тыс.
HOW DID SHE WIN??
00:49
Просмотров 15 млн
5 DAX Debugging Tricks!
18:26
Просмотров 4,5 тыс.
Getting Started with Calculation Groups in Power BI
23:09
3 Ways to use Calculation Groups You Need to Know
20:00
7 Simple Concepts of Writing Powerful DAX  🔥
16:07
Просмотров 19 тыс.
DAX Summarization Tricks in Power BI
12:51
Просмотров 20 тыс.
DAX Power BI Tuto FR | Somme cumulée en DAX (YTD)
9:20
My number 1 trick for TIME INTELLIGENCE  | Power BI DAX
11:13