I am so happy I found your channel! I have been trying to solve this exact problem for over a week now when I stumbled across your channel. This was exactly what I was looking for and your explanations were incredible! Thank you so much for this video!!!!
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
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).
Your video is amazing. I just have a question but what if we are trying to show a sales trend in that case also it should work the same way like aug to aug or we can consider 12 months?
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.
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!
I am very new to Power BI and was wondering if your Growth calculation will work if we want to look at multiple years? If my current year is only 9 months worth of data will it compare only 9 months of each year or will the older years compare all 12 months? Thank you!
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.
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?
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.
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.
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
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.
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
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
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
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
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
I am so happy I found your channel! I have been trying to solve this exact problem for over a week now when I stumbled across your channel. This was exactly what I was looking for and your explanations were incredible! Thank you so much for this video!!!!
Your explanations are amazing man! AMAZING!
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.
Wonderful! Your channel is ALWAYS beneficial! Thank you!
Wow, thank you!!!!
You are a gifted teacher. You explained everything in such detail. Keep them coming, please!
Thank you for your beautiful words! 💚
Super explained, definitely the best channel for PBI!
Wow, thanks!
You help me so much! Thank you!!! Love the content and your explanations.
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
Do we get any opportunities?
you explain Dax like no others .fantastic ❤
Thanks for your inspiring words 😊
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).
You saved my work brother! thank you
Excellent explanation.. you deserve more subscribers 👍
Oh, you help me a lot. !!!
Thank you for make this video.
awesome, thanks a lot bro! you're good, God bless you
Great video! How can you implement this with a fiscal calendar that has different start & end dates every year?
Really good and thorough explanation. Thank you
Glad you like it!
Your video is amazing. I just have a question but what if we are trying to show a sales trend in that case also it should work the same way like aug to aug or we can consider 12 months?
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.
GREAT VIDEO! THANKS!
Very Nicely explained, Do you have any videos on full dax functions?
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!
Thankyou so much chandeep!!!!!. 🤩
I am very new to Power BI and was wondering if your Growth calculation will work if we want to look at multiple years? If my current year is only 9 months worth of data will it compare only 9 months of each year or will the older years compare all 12 months? Thank you!
Excellent!!! 🎉🎉🎉
You are superb, Veerji😍
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.
3:06 even we can use DATEADD right
Any suggestions how to calculate QoQ growth based on fiscal Calendar.
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?
Very helpful
Goodly is the best bro
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.
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.
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
Wonderful!!
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?
You are doing amazing support
Thank you! 😊
This is a very goodly done video 😁
Thanks Grave 😄
Burraaaaaa paji ❤
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.
Returns same values of current month. I have put the same DAX formula but it is not returning previous month value.
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
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
You cannot use userelationship If you want to add row level security after, so Goodly solution is better.
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.
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
That was great, cheers
Thanks!
How to do a q/q growth where I don’t have any date, I only have the quarter number and year
OMG THANK YOU
Glad You like it!
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
Respect 🫡
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
great one !!
Thank you!! 😊
Can we do this for quarters
Just drag the quarter in the visual.. nothing changes.
First one to like and comment 👍
Perfect
Thanks 💚
how to showed
the highest growth between FY 2019
and 2023.
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
Never Mind, I figured it out
Additionally, you don't need the calculate in there!
Can you please share the PBIX file for practice
goodly.co.in/wp-content/uploads/2022/06/Calculate-Fiscal-Year-Growth-over-Last-Year.zip