Scenario: ROLLING 12 MONTHS Average Sales | Power BI Interview

[@AllaboutExperienceReshh]

Even your vedios are awesome,learning a lot from them,please share with one common dataset,so that we too practise on it immediately.Great job bro,a big big big thanks to you

[@rajatdixit11]

Again back with one more bang on Scenario based questions..Hats off to your efforts 😊 ..keep up the good work ! 🙏

[@learnwidgiggs]

Thanks a lot 😊

[@pranavvenkata475]

Can you please provide the datasets under each video fo practice? great video btw :)

[@shr9417]

This is possible only when we have different dates, What if we have same dates with different time period

[@saikumar-vt5th]

How do finding rolling averages month-wise, and what type of measures are we created?

[@vishalsonawane.8905]

Calendar Table is don't know in your video, Could you please attached the Power BI file or Excel Sheet on your videos. So its Great Help to all of us!!!!

[@AllaboutExperienceReshh]

And aslo can you please try to make a vedio on on all time intelligence functions mostly used at one place like today,last week,rolling sales with upto date data/given data of previous years...etc.Its of great help

[@Mahesh717]

sir, what is the diff between Running 12 months avg sales vs Cumulative sales ?

[@learnwidgiggs]

Running 12 months avg sales means one has to calculate the average sales happened in the past 12 months from the current month ...dynamically Cumulative Sales means all the sales that happened till current month.

[@naveenshindhe2893]

Calendar table, show the data please

[@priyankasarkar6600]

Hi Shashank, Can you please make a video on fiscal month, where sales start from April this year to March next year? For this scenario, I am using the below DX, but can you please make a video on this? Thanks in advance. fiscal month_ = IF('calendar table'[month]>3, 'calendar table'[month]-3, 'calendar table'[month]+9)

[@learnwidgiggs]

Noted

[@RP-ri5om]

insted of max (calender_tabe [date]) can we make use of lastdate (calender_tabe [date]) here could you please answer this sir?

[@sarihaddu]

The grand total at bottom of the running 12 months average column is not correct, how to get correct value there, is it required?

[@learnwidgiggs]

I have uploaded a seperate video on .. correcting the totals..plz check that video out from the playlist

[@Queen.himshi]

Hey Hi, I am confused why you have used Average, why we are not dividing by 12. as I have seen your rolling average calculation video in that we are dividing in calculation

[@hairavyadav6579]

Hello Sir, Please let me know this will work or not 12th month = var a= LASTDATE(Sheet1[Order Date].[Date]) var b = DATEADD(a,-12,MONTH) RETURN CALCULATE(AVERAGE(Sheet1[Sales]),Sheet1[Order Date]>=b)

[@AllaboutExperienceReshh]

Hi bro,can you please make vedios by taking a standard dataset like coffee chain ,sample super store data sets...etc....so that we can practice & concept also will be very clear.Otherwise,we are understanding & sometimes missing it after some days.Please take it a positive feed back.Rahul bro makes tableau scenario based vedios like that only

[@sreemalapal]

This is same approach or same concept to Calculate the sales for the last 7 days

[@learnwidgiggs]

Yeah the concept is same but since people get confuse ..so I have put it separately

[@akshaygupta2398]

Sir please bring video how to find job of Power bi from different platforms easily 🙏🙏 ?

[@learnwidgiggs]

Will try

[@easypowerbi6963]

Great work... 👍 Appreciated

[@learnwidgiggs]

Thank you! Cheers!

[@SantoshKumar-yr2md]

Can you suggest instead of Today why using max in datesinperiod

[@learnwidgiggs]

So that we can also do and include the calculation on the basis of selection made by the user.

[@SantoshKumar-yr2md]

@@learnwidgiggs can you have one project recording

[@prajaktak6475]

What if instead of max date ,min date is given and interval is specified as +12 instead of -12 ..will the result be same?

[@learnwidgiggs]

No, this is not a right way to approach the scenario...it might work here on this small data and one visual but should not be used in general.

[@Adityaaaar366]

Sir, Can we use dateadd also instead?

[@learnwidgiggs]

No

[@f4fuaad]

Averagex(filter(All(calender (Date), calendar (date)

[@f4fuaad]

We can use this also

[@learnwidgiggs]

I believe this should not work here.

[@ShyamSundar-vu2pp]

​@@learnwidgiggscan we use datesytd instead of Datesinperiod please reply