Please more scenario based power bi questions like this.please do one video on how to increase the performance of the report step by step.That would be helpful.
Type this videos are very informative......please use more dax.....Your all video is different from others video... Please make full interview mock to scenario based question full process of hire combine all question...
Very Helpful, I'm the new subscriber . Can you please make video on all the Dax function, which is helpfull for fresher and intermediate level person, as per the interviewer perspective
Thanks for sharing. Sir, if we have two tables. one is customer and second is sales and we wish to pull date week wise. Could you please suggest. couple of times interviewers asked me. pls suggest. Many Thanks
Very very wonderful video with clear clarity bro,can you also make video on when we have to use which type of charts and what values can we take in x axis and y axis i mean what type of data should be taken on x axis and y axis
It's really great... understood each and every part in video.. can you add more videos like this and a video on more complex dax queries asked for experienced
Hi, For scenario 2 YTD sales, I think YTD means everyday it should sum up the total sales and show the result until last day right, for ex MTD means from month day 1 to day 31st it should keep summing up previous day sales and show the result, but above YTD is just showing same result as sum of sales. it started from 1 jan 2023, so 2nd Jan YTD should be 3500.. and 3rd Jan should be 5000.... isn't it. Could you please confirm if my understanding is wrong ?
Dynamic Title Multiple Years = IF(ISFILTERED('Calendar'[Year]), "SALES INFORMATION FOR " & CONCATENATEX(VALUES('Calendar'[Year]), 'Calendar'[Year], ", ", "PLEASE SELECT YEAR FOR SALES DETAILS"))
Dear, when I try to create Data Table in the second question I get the notification "Too few arguments were passed to the CALENDAR function. The minimum argument count for the function is 2." What should I do? :)
Hi sir I am Rajashekar and I am practing your scenero sir but I am not getting wrong output sir I did practice two times but I am getting wrong output but I didn't understand why it is coming like that because of I practiced your data only but I didn't get proper result sir
Ther's a confusion on SENARIO 2, when you put totalytd on the visual why this was only showing for 2023, not for 2021,2022, also you haven't put any filter on 2023? can you please clarify , Actually I'm having an interview soon
aint the representation of fiscal year is wrong , in visualisation basically it took whole calender year and sorted in the order computed rather to represent oct 2020-sept 2021??
Please more scenario based power bi questions like this.please do one video on how to increase the performance of the report step by step.That would be helpful.
Sure
Your tutorials are at another level. Really useful and practical because I can always follow along because of the downloadable files.
Glad you liked it ✨
Very useful, clean explanation. This comes only by exp.
Such a great video, very crisp and to the point with proper explanation...Great Work
Superb video very useful for all the BI aspirants please try to make videos like this.
Type this videos are very informative......please use more dax.....Your all video is different from others video...
Please make full interview mock to scenario based question full process of hire combine all question...
Thanks bro
superb sir thank you for making interview series
Such an informative vdo, full of knowledge and new learning for a power bi beginner like me. Great work guys, keep it up.
Glad it was helpful!
thanku sir i learned a lot of things here😍😍
You are superb. Thanks a lot. Can you please create more of these kind of videos.
Hello
Can u please make a detail video on how the managerial round conducted,
Which type of scenario based questions ask
Definitely
Maaaaan this is just what I need. Great video!
Very Helpful, I'm the new subscriber . Can you please make video on all the Dax function, which is helpfull for fresher and intermediate level person, as per the interviewer perspective
I will try my best
Thankyou sir... it is very helpful, do make more videos in interview series.
Sure
Your channel is so useful! Thank you
I learnt a lot from this video and clear explanation.. Thanks for the video
Glad you liked 🙂
One word for this mindblowing
super explanation it helps me alot thanks😊
Glad to hear that
Perfect explanation sir.. thank you
Thanks for sharing.
Sir, if we have two tables. one is customer and second is sales and we wish to pull date week wise. Could you please suggest. couple of times interviewers asked me. pls suggest. Many Thanks
in the calendar table, we need to have the weekofyear column to perform week over week sales analysis for customers...
I am very Happy for this tyoe of videos just you are making for us thank you so much... Love you sir
Awesome Video for Practical Power BI Questions
Wow very helpful one .Please create more interview questions 🎉🎉🎉 lots of love
For 1st question, insted of tagging number, can just change the name or replace "Under 25" to "0-25", it will come at 1st position
Client requested to have under 25 then you have to do with this approach. Else your way would be better
Very very wonderful video with clear clarity bro,can you also make video on when we have to use which type of charts and what values can we take in x axis and y axis i mean what type of data should be taken on x axis and y axis
EXCELLENT.. THESE ARE FOR THE EXPERIENCE OR FRESHER LEVEL ?
Both
Thanks a lot, it's a helpful scenario,is there any possibility to proved the table file so try it myself,Thank again
Its available in description of the video
Very good Explanation.
and Thanks for the data provided in drive.
It's really great... understood each and every part in video.. can you add more videos like this and a video on more complex dax queries asked for experienced
Very usefull video.Thanks for giving dataset also. keep upload more videos like this. Great work👏👏
For scenario 5 : instead of color measure can we do it by conditional formatting as well?
Yes
For the last scenario can we give the dynamic colour using the rules options instead of field.y is field preferred here is this a good practice?
I appreciated your tutorial video. It is very useful.
Glad it was helpful!
useful information, Great for ur efforts
Thanks a lot
Second scenario no need calculate function only totalytd is enough
Agreed
Wonderful and very useful.
Amazing video, very helpful!! Thank you sooo much.
finished watching
Hi, For scenario 2 YTD sales, I think YTD means everyday it should sum up the total sales and show the result until last day right, for ex MTD means from month day 1 to day 31st it should keep summing up previous day sales and show the result, but above YTD is just showing same result as sum of sales.
it started from 1 jan 2023, so 2nd Jan YTD should be 3500.. and 3rd Jan should be 5000.... isn't it.
Could you please confirm if my understanding is wrong ?
Thank you!
Superb ...Very Helpful
How we will know which expression or formula we have to use to do certain calculations?
Can you please give me any tip or trick for this...
That comes with lot of practice and creating multiple dashboards
Can you make one video how to create table shows current and previous month sales based on slicer selection with direct query connection,thanks
Sir Thank you for this, upload as soon as next part
Sure
Hi, for scenario 4, what if the years are multi-selected? How do we display the values then?
Very gr8 info bro.
Great session
Wonderful brother 🎉🎉🎉
Kudos to your great efforts 😊
Thank you so much 😀
Man, that was awesome. Great job.
Thanks a ton!
Nice we want more vidoes bro🙏
I will try my best
In dynamic title, what if a user selects multiple years? or perhaps toggle the 'SELECT ALL'. How will the selected years be displayed?
Dynamic Title Multiple Years = IF(ISFILTERED('Calendar'[Year]), "SALES INFORMATION FOR " & CONCATENATEX(VALUES('Calendar'[Year]), 'Calendar'[Year], ", ", "PLEASE SELECT YEAR FOR SALES DETAILS"))
@@madhusudhanreddyt2838 Wonderful! BIG thanks.
Can you please provide any good source to learn DAX queries ?
thanks for your efforts..!!
Same question i got in my interview
Glad it helped and you answered all correctly
Great video Sir.
Great 👍 video
GREATE JOB BUDDY. PLEASE KEEP THESE AWESOME VIDEOS COMING.
While creating conditional column for the age group it showing null in many cells in power query. Can you explain why this happening??
Very Helpful videos...
Thanks sir
Welcome
Very nice video brother. Covered most of the challenging scenarios with their relevant solutions. Very well explained as well. Keep up the good work 👍
Glad it was helpful!
Sir did interviewer provide data according to scenario????
Yes
awesome video
i got this question in interview
love u and tq soo much broo😍
awesome
Dear, when I try to create Data Table in the second question I get the notification "Too few arguments were passed to the CALENDAR function. The minimum argument count for the function is 2." What should I do? :)
you need to give min and max dates
Hi sir I am Rajashekar and I am practing your scenero sir but I am not getting wrong output sir I did practice two times but I am getting wrong output but I didn't understand why it is coming like that because of I practiced your data only but I didn't get proper result sir
Ther's a confusion on SENARIO 2, when you put totalytd on the visual why this was only showing for 2023, not for 2021,2022, also you haven't put any filter on 2023? can you please clarify , Actually I'm having an interview soon
after creating the conditon column the age sort column is showing as null
Did you write condition properly, its case sensitive
great
usefull
Tq❤
Sales till today = CALCULATE(SUM(Sales[Sales]),DATESBETWEEN('Master date'[Date],DATE(2023,1,1),DATE(2023,5,23)))
can i also use this?
The dates are fixed here, make sure whatever dax u use is dynamic and do not need changes again and again
while calculating sort age value showing null
Scenerio 2- I am creating this in 2024, why its still giving me the output of 2023. It should be Blank for 2024
Make more
aint the representation of fiscal year is wrong , in visualisation basically it took whole calender year and sorted in the order computed rather to represent oct 2020-sept 2021??
Sir I need Excel data on College Infrastructure UTTILIZATION can Please Provide Me
the meaning of ytd is beginning of current calender year to todays date then why r u specifying it should be less than today
Can you share the excel sheets
In description of video
where is the data to downlaod
I didn't created any date table.
YTD_Mes =
CALCULATE(
TOTALYTD(
SUM('Sheet1 (2)'[Sales]),
'Sheet1 (2)'[Order Date].[Date]
),
FILTER(
'Sheet1 (2)',
'Sheet1 (2)'[Order Date]
Employee Age Group? LOL! Not in America, maybe that's how it's in India. I have to stop right here.
Goodbye Gramps 👋🏻
Cant we use filter and measure for second scenario?
If its of today in second scenario how they are showing sales in later date?