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!!!!
@veebee3969
Жыл бұрын
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.
@hamzasaqib511
Жыл бұрын
Your explanations are amazing man! AMAZING!
@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! 💚
@francismastro
Жыл бұрын
You help me so much! Thank you!!! Love the content and your explanations.
@AVielot
Ай бұрын
Wonderful! Your channel is ALWAYS beneficial! Thank you!
@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?
@BerndKammereck
Жыл бұрын
Super explained, definitely the best channel for PBI!
@GoodlyChandeep
Жыл бұрын
Wow, thanks!
@bharatgarg07
4 ай бұрын
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).
@ralaa82
2 жыл бұрын
you explain Dax like no others .fantastic ❤
@GoodlyChandeep
2 жыл бұрын
Thanks for your inspiring words 😊
@LAssu-pv4bo
6 ай бұрын
You saved my work brother! thank you
@gangababupatchipala3613
Жыл бұрын
Excellent explanation.. you deserve more subscribers 👍
@BlackForest-g3o
Жыл бұрын
Great video! How can you implement this with a fiscal calendar that has different start & end dates every year?
@seamushand8439
2 жыл бұрын
Really good and thorough explanation. Thank you
@GoodlyChandeep
2 жыл бұрын
Glad you like it!
@pa-ogaming4004
Жыл бұрын
Oh, you help me a lot. !!! Thank you for make this video.
@33inchil
8 ай бұрын
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.
@nsuresh1
Жыл бұрын
Very Nicely explained, Do you have any videos on full dax functions?
@sameerulhaq4066
Ай бұрын
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?
@baneledludlu7983
Жыл бұрын
awesome, thanks a lot bro! you're good, God bless you
@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
@reneebender7789
Ай бұрын
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!
@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.
@beingrishi6450
6 ай бұрын
3:06 even we can use DATEADD right
@isam6418
5 ай бұрын
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!
@sunitkhurana
6 ай бұрын
You are superb, Veerji😍
@sahalBD
6 ай бұрын
Any suggestions how to calculate QoQ growth based on fiscal Calendar.
@wakayn
2 жыл бұрын
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.
@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?
@pillajanardhankumar7369
2 жыл бұрын
Thankyou so much chandeep!!!!!. 🤩
@ExploringSoulwithAnneMarie
6 ай бұрын
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.
@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?
@thomasg1610
Жыл бұрын
GREAT VIDEO! THANKS!
@jaiconruedas
6 ай бұрын
Excellent!!! 🎉🎉🎉
@alirehman4041
Ай бұрын
Returns same values of current month. I have put the same DAX formula but it is not returning previous month value.
@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
@JohnSmith-rx2uv
10 ай бұрын
Goodly is the best bro
@zonziriguekonate1066
11 ай бұрын
Very helpful
@deeswift-z1h
5 ай бұрын
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.
@harikrishnannair7653
7 ай бұрын
Wonderful!!
@gravestoner2488
Жыл бұрын
This is a very goodly done video 😁
@GoodlyChandeep
Жыл бұрын
Thanks Grave 😄
@deepakmahendrakar5674
2 жыл бұрын
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.
@bhawanarai510
2 ай бұрын
How to do a q/q growth where I don’t have any date, I only have the quarter number and year
@smartwork4768
2 жыл бұрын
You are doing amazing support
@GoodlyChandeep
2 жыл бұрын
Thank you! 😊
@KumaranSivakumar-i2i
6 ай бұрын
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
@brightonalbert3237
Жыл бұрын
Can we do this for quarters
@GoodlyChandeep
Жыл бұрын
Just drag the quarter in the visual.. nothing changes.
@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
@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
how to showed the highest growth between FY 2019 and 2023.
@sarveshdeshpande1772
2 жыл бұрын
great one !!
@GoodlyChandeep
2 жыл бұрын
Thank you!! 😊
@deeptibisht8100
2 жыл бұрын
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
2 жыл бұрын
Never Mind, I figured it out
@GoodlyChandeep
2 жыл бұрын
Additionally, you don't need the calculate in there!
Пікірлер: 75