Easily the best explanation of EARLIER I have seen. Period.
@GoodlyChandeep3 жыл бұрын
Glad you found it helpful
@pravinshingadia73372 жыл бұрын
These function videos are the absolute best my friend. Learned more in a couple of hours from you then weeks trying to read and understand from a book
@sankalpparmar41624 жыл бұрын
This is just amazing. I was scratching my head for past 1 week to understand this nested row context process. Thanks a lot.
@GoodlyChandeep4 жыл бұрын
Thanks Sankalp, Glad you liked it :)
@ravichandirana89114 ай бұрын
One of the best videos I have seen that clearly explained the Earlier function
@misiael882 жыл бұрын
This is a great explanation, helps to actually understand what is happening and how to perceive both contexts. I had a really hard time to do that with other videos.
@Rafian19243 жыл бұрын
Simplest explanation of earlier function on this planet.
@sajilpulath73533 жыл бұрын
Oh man, another level of explanation 👍🏻
@Nalaka-Wanniarachchi4 ай бұрын
This is one of the fabulous example I have came across in DAX. Epic explanation .👍
@alterchannel25017 ай бұрын
You exactly know how to explain things and make them seem simple. Thank Chandeep
@malchicken3 жыл бұрын
Oh wow, I finally understand what Earlier does, thank you 🙏
@priteshkhilari19186 ай бұрын
Thanks alot brother! It means alot to me
@helios99 Жыл бұрын
Wow, I was struggling to understand the concept behind this, but your video was the most effective for me. Thank you so much for this detailed explanation.
@johntobin35084 жыл бұрын
Excellent video. I definitely appreciate your style of explanation. This really helped me understand uses for the EARLIER function.
@GoodlyChandeep4 жыл бұрын
Glad it was helpful!
@williamarthur4801 Жыл бұрын
This is a really good introduction to Earlier, also had a few spin offs, I first tried using a variable instead of Earlier, not as straight forward as I'd have thought, and then doing it in excel cross tab which I never quite got to work, had all the percentages, but getting the correct budget into each cell proved tricky.
@pillslifestylereviews671424 күн бұрын
This is one of the functions people term as "Elven Magic"!
@christyokane65273 жыл бұрын
Trying to figure out a problem for so so long and this video finally got me there! Thank you so much, it was a massive help :)
@GoodlyChandeep3 жыл бұрын
Great to hear!
@jaimansourimohammedamine53957 ай бұрын
Hello, I appreciate the quality of your videos and commend you for the clarity of your explanations. I'm wondering if it's possible to apply the "Earlier" function in a DAX measure for calculating the cumulative total of revenue by product category, for instance. Based on the example you provided using the "COUNTROWS" function, I couldn't figure out how to adapt it with the "SUMX" function to achieve cumulative total through a measure instead of a column. Thank you in advance for your response.
@dessaleeyasu11424 жыл бұрын
Great Explanation !! could you also do a video on power bi API for power query. Thanks !!
@akshat87382 жыл бұрын
Incredible explanation..!! Many thanks for this video
@mehulbhatia32413 жыл бұрын
Best ever explanation. Please continue to add more videos.
@GoodlyChandeep3 жыл бұрын
More to come!
@TheBirdChannelOriginal2 жыл бұрын
That's a great explanation!, thanks
@GoodlyChandeep2 жыл бұрын
Glad you like it 😊
@user-oh3ry1zn2q11 ай бұрын
Thank you so much. My concept got cleared. I would request you Pls tell me where i can get this data set. Not able to find download files and blog section.
@cristian.angyal4 жыл бұрын
Great explanation! Finnaly got the idea about EARLIER when gou compared it to COUNTIF! Thanks!
@GoodlyChandeep4 жыл бұрын
Glad it was helpful!
@marliearcellia12893 жыл бұрын
10:57 was the measure meant to allocate the exact same amount to every row of the same region? I mean let's say that there are 20 rows of Mumbai, and 1/20 = 5%. So the display should show every row of Mumbai gets 5% x 25000 = 1250, shouldn't it? Why then every row of Mumbai gets different budget allocation? Could you please explain more? Thank you
@abhishek8338 Жыл бұрын
hi i have same question
@JapjeetS2 жыл бұрын
Explained Very well Thank you
@senthilkumarchandrasekaran18272 жыл бұрын
Neat and clean explanation ! Thankyou for your efforts !
@GoodlyChandeep2 жыл бұрын
Thank you for your appreciation 😊
@blse20004 жыл бұрын
Awesome...your are a great teacher...please keep posting more videos
@GoodlyChandeep4 жыл бұрын
Thank you, I will
@changyuesin14934 жыл бұрын
superb explanation, would love to see more dax videos coming from you!
@GoodlyChandeep4 жыл бұрын
More to come! Cheers
@venkatareddykummitha58632 жыл бұрын
Awesome explanation.
@rahulmanandhar4801 Жыл бұрын
Thanks
@GoodlyChandeep Жыл бұрын
Thanks for the tip!
@patrickf012 жыл бұрын
fantastic explanation
@briceleblanc26062 жыл бұрын
thank you very much !
@pallavijain3957 Жыл бұрын
Hi, Thank you for excellent explanation. I am stuck in a similar problem..but my dates are not in hierachy.. my dates are like this 1. 22 Apr 2. 25 Apr 3. 4 May Now, min date : 22 Apr Max date: 4 may I have to find date prior to max date....i.e 25 Apr... How to achieve this? Pl share, if you have any solution for this problem
@surajchavan6447 Жыл бұрын
Awesome 😎😎
@GoodlyChandeep Жыл бұрын
Thanks!
@dundosan10852 жыл бұрын
What if I want to accumulate values (based on date) but separated for each value of the other column (for example column client contains client 1, 2 and 3). I'd want to accumulate it separately for each one, rather than together. Thanks!
@abhishek8338 Жыл бұрын
I don't understand, according to me every single product in a region should have equal budget allocation since we are doing budget /count of region occurances
@philipmathew65422 жыл бұрын
Hi Chandeep...nice video. Can you provide a short summary of the "iterator functions" in Power BI....many thanks.
@GoodlyChandeep2 жыл бұрын
See this - kzfaq.info/get/bejne/aqeBqdhl0Nu3iZc.html
@parthsoni42796 ай бұрын
Hello big request that you can share the dummy data with us to practice along with other information
@GoodlyChandeep6 ай бұрын
Here is the file - goodly.co.in/?ebddl=4e8c699067
@VimalKumar-kz6yg2 жыл бұрын
If want to escape empty value what to do
@edwinfcapidos5 ай бұрын
Tried this function and it only works with a small dataset. I ended up making the calculations in source data.
@pushpalatha281210 ай бұрын
Hiii..pls help me to find a consecutive 3days product failure in a week.. if product got failed continuous 3 days in a week i need that result in True or false
If that is a calculated column. Calculated column produces a row context and FILTER produces the other. If that is a measure, I doubt that is going to work.
@sane72632 жыл бұрын
@@GoodlyChandeep it's CC thankx!
@ramakrishnaravula18193 жыл бұрын
superb
@sravankumar17673 жыл бұрын
it is little bit tricky , first example i can understand but second example is too much tough little bit tough can u explain it