So same i can create two parameter for user input and map those two parameters in calculated fields to get sales during given period of time???? It was asked yesterday in my second round
CURRENT YEAR sales IF [Order Date]>=DATETRUNC('year',[Select date])AND [Order Date]=DATEADD('year',-1,DATETRUNC('year',[Select date])) AND [Order Date]
Very Useful boss
Thanks Brother
Thank you so much for your valuable videos.. 🙏🙏
❤️
Wow ..bhai u r great..so much things to learn from you ☺️
Thanks Gudiya 🤝😄😄
HI Rahul Bro your videos very useful for interviews
Thanks Brother 😊
So same i can create two parameter for user input and map those two parameters in calculated fields to get sales during given period of time????
It was asked yesterday in my second round
You can Definitely.... Brother pl share ur interview scenarios so that it can be of help to others.
@@TechiRahul u r the reason... I am in final managerial round bhai..all advance knowledge i got from you and your channel
@@TechiRahul but bhai...is it ryt way what i comment to get sales during given period
Happy to hear this ☺️🤝
Can we add date filter here (instead parameter), here we have flexibility to select only single date. what if user wants to select a month?
Yes we can do... just need to optimise calculation little bit to fit the requirement
@@TechiRahul If possible, please make a video on it as well, thanks in advance
CURRENT YEAR sales
IF [Order Date]>=DATETRUNC('year',[Select date])AND
[Order Date]=DATEADD('year',-1,DATETRUNC('year',[Select date]))
AND [Order Date]
Superb
@@TechiRahul , THNAK YOU ,,,please upload full live interview questions
Current year vs previous years sales representation using filters is possible?
Yes possible
Hi can you suggest can we find the previous day sale without parameter..
I want to find date filter, another filter for 7 days sale with selected date and selected date vs previous date sale… plz help in this
Sure will try to come up with a video on this.