Easily the best explanation of EARLIER I have seen. Period.

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

This is just amazing. I was scratching my head for past 1 week to understand this nested row context process. Thanks a lot.

One of the best videos I have seen that clearly explained the Earlier function

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.

Simplest explanation of earlier function on this planet.

Oh man, another level of explanation 👍🏻

This is one of the fabulous example I have came across in DAX. Epic explanation .👍

You exactly know how to explain things and make them seem simple. Thank Chandeep

Oh wow, I finally understand what Earlier does, thank you 🙏

Thanks alot brother! It means alot to me

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.

Excellent video. I definitely appreciate your style of explanation. This really helped me understand uses for the EARLIER function.

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.

This is one of the functions people term as "Elven Magic"!

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 :)

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.

Great Explanation !! could you also do a video on power bi API for power query. Thanks !!

Incredible explanation..!! Many thanks for this video

Best ever explanation. Please continue to add more videos.

That's a great explanation!, thanks

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.

Great explanation! Finnaly got the idea about EARLIER when gou compared it to COUNTIF! Thanks!

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

Explained Very well Thank you

Neat and clean explanation ! Thankyou for your efforts !

Awesome...your are a great teacher...please keep posting more videos

superb explanation, would love to see more dax videos coming from you!

Awesome explanation.

Thanks

fantastic explanation

thank you very much !

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

Awesome 😎😎

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!

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

Hi Chandeep...nice video. Can you provide a short summary of the "iterator functions" in Power BI....many thanks.

Hello big request that you can share the dummy data with us to practice along with other information

If want to escape empty value what to do

Tried this function and it only works with a small dataset. I ended up making the calculations in source data.

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

This is awesome

= COUNTROWS(FILTER(ProductSubcategory, EARLIER(ProductSubcategory[TotalSubcategorySales])

superb

it is little bit tricky , first example i can understand but second example is too much tough little bit tough can u explain it