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
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!!!!
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.
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)
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
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
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)
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
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
Again back with one more bang on Scenario based questions..Hats off to your efforts 😊 ..keep up the good work ! 🙏
Thanks a lot 😊
How do finding rolling averages month-wise, and what type of measures are we created?
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!!!!
This is possible only when we have different dates, What if we have same dates with different time period
Can you please provide the datasets under each video fo practice? great video btw :)
sir, what is the diff between
Running 12 months avg sales
vs
Cumulative sales ?
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.
The grand total at bottom of the running 12 months average column is not correct, how to get correct value there, is it required?
I have uploaded a seperate video on .. correcting the totals..plz check that video out from the playlist
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)
Noted
Calendar table, show the data please
Great work... 👍 Appreciated
Thank you! Cheers!
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
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
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)
This is same approach or same concept to Calculate the sales for the last 7 days
Yeah the concept is same but since people get confuse ..so I have put it separately
Can you suggest instead of Today why using max in datesinperiod
So that we can also do and include the calculation on the basis of selection made by the user.
@@learnwidgiggs can you have one project recording
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
What if instead of max date ,min date is given and interval is specified as +12 instead of -12 ..will the result be same?
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.
Sir, Can we use dateadd also instead?
No
Averagex(filter(All(calender (Date), calendar (date)
We can use this also
I believe this should not work here.
@@learnwidgiggscan we use datesytd instead of Datesinperiod please reply
Sir please bring video how to find job of Power bi from different platforms easily 🙏🙏 ?
Will try