EARLIER Function in DAX

Learn how the DAX EARLIER function works in Power BI.
Download Files and Blog - www.goodly.co.in/earlier-func...
- - - - My 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...
- - - - Blog - - - -
www.goodly.co.in/blog

[@minurapunchihewa4592]

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

[@GoodlyChandeep]

Glad you found it helpful

[@pravinshingadia7337]

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

[@ravichandirana8911]

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

[@sankalpparmar4162]

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

[@GoodlyChandeep]

Thanks Sankalp, Glad you liked it :)

[@Nalaka-Wanniarachchi]

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

[@Rafian1924]

Simplest explanation of earlier function on this planet.

[@misiael88]

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.

[@sajilpulath7353]

Oh man, another level of explanation 👍🏻

[@alterchannel2501]

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

[@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.

[@christyokane6527]

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

[@GoodlyChandeep]

Great to hear!

[@malchicken]

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

[@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.

[@johntobin3508]

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

[@GoodlyChandeep]

Glad it was helpful!

[@akshat8738]

Incredible explanation..!! Many thanks for this video

[@changyuesin1493]

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

[@GoodlyChandeep]

More to come! Cheers

[@JapjeetS]

Explained Very well Thank you

[@cristian.angyal]

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

[@GoodlyChandeep]

Glad it was helpful!

[@priteshkhilari1918]

Thanks alot brother! It means alot to me

[@venkatareddykummitha5863]

Awesome explanation.

[@mehulbhatia3241]

Best ever explanation. Please continue to add more videos.

[@GoodlyChandeep]

More to come!

[@senthilkumarchandrasekaran1827]

Neat and clean explanation ! Thankyou for your efforts !

[@GoodlyChandeep]

Thank you for your appreciation 😊

[@jaimansourimohammedamine5395]

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.

[@TheBirdChannelOriginal]

That's a great explanation!, thanks

[@GoodlyChandeep]

Glad you like it 😊

[@blse2000]

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

[@GoodlyChandeep]

Thank you, I will

[@briceleblanc2606]

thank you very much !

[@dessaleeyasu1142]

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

[@patrickf01]

fantastic explanation

[@saisatya5525]

This is awesome

[@user-oh3ry1zn2q]

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.

[@marliearcellia1289]

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

[@ramakrishnaravula1819]

superb

[@surajchavan6447]

Awesome 😎😎

[@GoodlyChandeep]

Thanks!

[@rahulmanandhar4801]

Thanks

[@GoodlyChandeep]

Thanks for the tip!

[@dundosan1085]

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!

[@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

[@philipmathew6542]

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

[@GoodlyChandeep]

See this - kzbin.info/www/bejne/anK0p6hqoNqGj8U

[@pushpalatha2812]

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

[@parthsoni4279]

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

[@GoodlyChandeep]

Here is the file - goodly.co.in/?ebddl=4e8c699067

[@edwinfcapidos]

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

[@VimalKumar-kz6yg]

If want to escape empty value what to do

[@sane7263]

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

[@GoodlyChandeep]

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.

[@sane7263]

@@GoodlyChandeep it's CC thankx!

[@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

[@sravankumar1767]

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