Calculate Growth over Last Year by Fiscal Year in Power BI

Подписаться 89 тыс.

Просмотров 46 тыс.

50% 1

In this video, I'll take you through all the nuances of Calculating Growth over Last Year for both the Calendar and Fiscal Year.
===== ONLINE COURSES =====
✔️ 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 🔗 =====
Download File ⬇️ - goodly.co.in/wp-content/uploa...
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
===== CHAPTERS =====
0:00 Intro
0:30 Understanding Filter Context for Growth Calculations
2:55 Growth Calculation for Calendar Year
7:30 Adjust Totals - Comparing Sametime Periods
14:40 Growth Calculation for Fiscal Year
17:23 My Courses
===== 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'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall RU-vid Channel Below
ru-vid.com/show-UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

Наука

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

2 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 68

@hamzasaqib511 Год назад

Your explanations are amazing man! AMAZING!

@francismastro Год назад

You help me so much! Thank you!!! Love the content and your explanations.

@veebee3969 9 месяцев назад

Thank you. Very helpful video. I'm a newbie and will go through the video a couple of more times to fully digest the content.

@ginaramirez2313 2 года назад

Wow, thank you!!!! You are a gifted teacher. You explained everything in such detail. Keep them coming, please!

@GoodlyChandeep 2 года назад

Thank you for your beautiful words! 💚

@LAssu-pv4bo 3 месяца назад

You saved my work brother! thank you

@BerndKammereck Год назад

Super explained, definitely the best channel for PBI!

@GoodlyChandeep Год назад

Wow, thanks!

@thomasg1610 9 месяцев назад

GREAT VIDEO! THANKS!

@pa-ogaming4004 10 месяцев назад

Oh, you help me a lot. !!! Thank you for make this video.

@pillajanardhankumar7369 2 года назад

Thankyou so much chandeep!!!!!. 🤩

@baneledludlu7983 Год назад

awesome, thanks a lot bro! you're good, God bless you

@gangababupatchipala3613 9 месяцев назад

Excellent explanation.. you deserve more subscribers 👍

@jaiconruedas 2 месяца назад

Excellent!!! 🎉🎉🎉

@ralaa82 2 года назад

you explain Dax like no others .fantastic ❤

@GoodlyChandeep 2 года назад

Thanks for your inspiring words 😊

@seamushand8439 Год назад

Really good and thorough explanation. Thank you

@GoodlyChandeep Год назад

Glad you like it!

@bharatgarg07 Месяц назад

Hi, I like the method of explaining all the concepts in an easy and understandable way. Please also explain why you used Divide(CY,LY)-1 instead of just Divide(CY,LY).

@harikrishnannair7653 4 месяца назад

Wonderful!!

@David.Savage Год назад

That was great, cheers

@GoodlyChandeep Год назад

Thanks!

@johnj2041 Год назад

Hi Goodly, Fantastic video ! In the UK we often work with 4-4-5 week months for a financial year. It would make a good video to build a date table and some growth and average analysis etc for this kind of financial year. BI is growing fast in the UK

@Convivialranjan Год назад

Do we get any opportunities?

@zonziriguekonate1066 8 месяцев назад

Very helpful

@sunitkhurana 3 месяца назад

You are superb, Veerji😍

@smartwork4768 2 года назад

You are doing amazing support

@GoodlyChandeep 2 года назад

Thank you! 😊

@JohnSmith-rx2uv 7 месяцев назад

Goodly is the best bro

@sarveshdeshpande1772 2 года назад

great one !!

@GoodlyChandeep 2 года назад

Thank you!! 😊

@Dev_Bartwal 8 месяцев назад

Burraaaaaa paji ❤

@gravestoner2488 Год назад

This is a very goodly done video 😁

@GoodlyChandeep Год назад

Thanks Grave 😄

@nsuresh1 Год назад

Very Nicely explained, Do you have any videos on full dax functions?

@wakayn Год назад

Thank you for the useful videos. A request: I need to multiply sales of different fiscal years by a different number (factor). For e.g., if FY20, multiplication factor is 89%; if FY21, 87% and so on. Thank you so much for your help.

@ilanapregen1684 Год назад

OMG THANK YOU

@GoodlyChandeep Год назад

Glad You like it!

@user-un6to6ry7q 9 месяцев назад

Great video! How can you implement this with a fiscal calendar that has different start & end dates every year?

@Alireza-ih5vu 2 года назад

Perfect

@GoodlyChandeep 2 года назад

Thanks 💚

@33inchil 5 месяцев назад

Hello Goodly, I used this and it worked like a dream! Thank you very much. I would like to know how it can be amended to compare yearly spend to a baseline year (currently 2019/20 due to the impact of COVID-19. Thanks for your help.

@anitarusso269 Год назад

Thank you very much for the video. I have a question. When I apply a filter on the category to calculate growth by category, the formula does not work anymore. How can I fix it?

@beckyfosterman6163 Год назад

This is amazing and super helpful. I am having a difficult time finding a way to do this calculation, but with a fiscal calendar that changes dates every year. We have 13 periods and each period is 28 days. Any guidance or tips would be extremely helpful.

@gravestoner2488 Год назад

Add a day of year index column to your date table. Start it at 0. Divide the index by 28, remove the decimal, and add 1, and leave the whole number in a column called "period" then do it again, this time find the remainder of the division, add 1, this is the date within the period. Day 28 of the year = 28th day of 1st period. 28 = index 27 27/28 = 0.decimal - decimal + 1 = period 1 27/28 reminder = 27 + 1 = 28th day in period

@unitedwings7644 Год назад

Hey hi in powerbi I want to compare a value for continuous 15 mins if the value is same for 15mins continuously and I need a count 1 for that

@sahalBD 3 месяца назад

Any suggestions how to calculate QoQ growth based on fiscal Calendar.

@luisfernandomacedo1451 Год назад

Can I use this calculation to display values for quarter For example: in 2023 Q1 it should display the values considering the sum of last 4 quarters?

@isam6418 Месяц назад

How to achieve such a result on a daily basis? Seems to work perfectly on a monthly basis and total Fiscal year. Thank you! Would appreciate your help!

@ExploringSoulwithAnneMarie 3 месяца назад

Thank you. How did you do the totals sales calculations-I tried to find it in your playlist but I could not? I am using sameaspreviousyear to calculate PY, but it’s returning the incorrect value. I don’t know what I am doing incorrectly. My data is L12M by day CY & PY and I’ve sorted it by fiscal period.

@monumax3183 20 дней назад

Respect 🫡

@sardhashakti 2 года назад

Hello Sir, Like to see your videos and helping a lot, I have s query which i discussed with lots of people but none from them are able to solve . I have 2 month order data wherein i have to calculate current wk monday, tuesday, last week, monday, Tuesday and last 7wk monday, tueday average from all dates and weeks. Can you please help in calculating this query..thanks in advance

@AbhishekPandey-ie2rk 2 года назад

First one to like and comment 👍

@deepakmahendrakar5674 Год назад

I am facing issue with modeling on the same scenario as i am not getting the actual value for the Previous Financial Year. # Need help.

@beingrishi6450 3 месяца назад

3:06 even we can use DATEADD right

@user-cz2yu1li2q 2 месяца назад

Hi, In my Month on month comparison, I need %change for previous month, I am getting proper result while the change is going for an unavailable next month (I have data from Jan to April, while its going for May and giving -100 for May month which isn't available ) and gives wrong value as total. Kindly help. I am working for matrix presentation here.

@brightonalbert3237 11 месяцев назад

Can we do this for quarters

@GoodlyChandeep 11 месяцев назад

Just drag the quarter in the visual.. nothing changes.

@KMYeahia 2 года назад

Can you please share the PBIX file for practice

@GoodlyChandeep 2 года назад

goodly.co.in/wp-content/uploads/2022/06/Calculate-Fiscal-Year-Growth-over-Last-Year.zip

@Yuvasena Год назад

I only have data like week number wk-1 wk-2.. til wk52, Quarter1 ,2 ,3 ,4, and FY 18-19 19-20 21-22 22-23 , how to get last year's sale from week number THE ARE NO DATES IN DATA

@jazzista1967 2 года назад

Great video... Quick question: Why are you using 2 calendars instead of one? You could have one calendar and have one active date relationship and use a calculate modifier like Userelationship ... What am I missing? Thank you

@MichalTyborski 2 года назад

You cannot use userelationship If you want to add row level security after, so Goodly solution is better.

@user-gx3sz5pe7c 3 месяца назад

Why my total show value as previous year values. I used your same measure. Still showing same result (By right last year values show in the current year right Pls help

@deeptibisht8100 Год назад

I Have a Dax using the same function, but it is not working and giving me error ADR Var LY = VAR CY1 = [ADR TY] VAR CY2 = [ADR LY] VAR check = CY1 & CY2 RETURN IF (CHECK, CALCULATE([ADR TY]-[ADR LY])) This is giving me the error calculation error in measure , cannot convert value 242.35106430 of type text to type true/false can you please help

@deeptibisht8100 Год назад

Never Mind, I figured it out

@GoodlyChandeep Год назад

Additionally, you don't need the calculate in there!