whenever you using rolling you have to use today function instead of max of order date then only you will able to get the exact rolling part. for historical data only you have to use the max function
Hi Kapil, Regarding the Rolling Quarter Sales question I had checked and the below formula returned the current quarter sales i.e. Sales for October, November and December IF DATEDIFF('quarter', [Order Date], {MAX(Order Date)}) = 0 THEN [Sales] END and if the DATEDIFF is equated to 1 we will get the previous quarter sales i.e. Sales for July, August and September Kindly confirm if my understanding correct? Regards, Deepak.
Nice video...
For the last question simple formatting for above and below average areas would distinguish enough
The way you explain the answers it is really impressive :)
Thank you so much for the feedback 🙏
looking for more videos like this...and thanks for making this videos
Thank you. Keep watching my videos
Thanks Kapil for this. Waiting for more complex scenario based question.
Thank you so much Harsh. You will get a new video today... Stay tuned
whenever you using rolling you have to use today function instead of max of order date then only you will able to get the exact rolling part. for historical data only you have to use the max function
Hi Kapil,
Regarding the Rolling Quarter Sales question
I had checked and the below formula returned the current quarter sales i.e. Sales for October, November and December
IF DATEDIFF('quarter', [Order Date], {MAX(Order Date)}) = 0
THEN [Sales]
END
and if the DATEDIFF is equated to 1 we will get the previous quarter sales i.e. Sales for July, August and September
Kindly confirm if my understanding correct?
Regards,
Deepak.
Hi Deepak, you are always correct 💯😜
Good video..nice explanation
Thank you so much 😊
U r just solving... not explaining sir... nice video sir👍
Thank you for your feedback. I will keep a note and will try to explain more in upcoming videos. Stay tuned...
👍
Thankyou 😊