Power BI Scenario based interview questions with solution | Power BI interview | Power BI |

[@AshishTiwari-ug2lg]

Hey Man, I have been working as a power BI developer for more than 1.5 years and the way of your teaching is something extraordinary. I have seen many videos of Dax, but people who are teaching are expressing themselves like they are full of knowledge and even they are showing that DAX is rocket science and unable to break down this easily. Kudos to you brother that you made it simple. I subscribed to you and wish you all the best in your future. Love You, Brother.

[@Irfankhan_56]

Refer us also bro. That will help any one of us in this community. Finding a powerbi job's now a days very tough.

[@TwoMinutesisEnough]

You are champion and I have subscribed as part of that 80%

[@datatutorials1]

Thanks you bro

[@Learnings-1990]

You are awesome 😎👍

[@biswadeepsahoo]

Your explanation skill is excellent

[@Dheeraj-k6m]

You are simply superb, thanks a ton for helping the unknown like me unconditionally. Grateful.🙏

[@yamin800]

Please add more videos like this, loved it

[@aruchique]

Very useful videos!

[@ashish90702]

Thanks a lot for this video 👍👍 Please provide more such interview related Power BI videos

[@riasingh11]

what great learning i've had! 🌟

[@shambavivusirikala1355]

Thanku for ur informative videos...lot of knowledge to gain

[@ramshataqdees5570]

thanks alot.... please make more vdos on powerbi scenario based interview questions

[@akshayyelwande-j7j]

Very Useful content,Thank You Sir.

[@datatutorials1]

Keep watching

[@beneficial4u572]

Subscribed, Please keep on posting

[@datatutorials1]

Thanks

[@emilyamalkin4367]

Thank you! I love your videos you your presentation style 👍🏻👍🏻👍🏻👍🏻👍🏻❤

[@amalayadav7406]

Nice explanation Sir. Please post Power BI course videos on all the topics.

[@vishwassharma3312]

Kindly Upload more such type videos?

[@shivang18]

For third scenario, we could have used YEARTD function

[@vishalsonawane.8905]

Thanks for sharing data and please make video on Dynamic Slicers on Different Date because In TCS interview they ask me the Question.

[@nidhisingh4973]

Can you please elaborate the question?

[@vishwassharma3312]

Sir . Is your play list enough to give an interview on power bi with 2 years of experience?

[@abrahamvincent6272]

Hi Sir, In scenario 1, we can take 'Today' function instead of 'Max(calender(date))' function right? in Datesinperiod function.

[@datatutorials1]

Yes if you are working with real time data

[@himanshubasra4451]

Whey cant we use Dateinperiod or totalytd in scenario 3 any idea?

[@aishwaryapattnaik3082]

Your videos consistently offer excellent content and valuable insights. This one cleared up a long-standing confusion I had between rolling sums and running sums, and I'm genuinely thankful for that.😇 If possible, could you please offer a solution for scenario 1, where dealing with inconsistent dates or months when calculating rolling sums becomes a challenge? Your content is highly appreciated, and I'm looking forward to more of it in the future.

[@emilyamalkin4367]

You need to link your “inconsistent date” to the date in the date table (which is always consistent) , and then use the date from the date table to calculate your totals.

[@kapur.betzy2023]

Absolutely loving the content! Subscribed today and already binged most of the videos. 😄 Could you create more full-scale projects like the ones on Maven and Onyx? Your teaching style is unique, and your voice is quite soothing. Thanks for the awesome content!"

[@abhishekchaturvedi6981]

Can't we use direct functions for running total like YTD, MTD type ?

[@datatutorials1]

How will you use these functions here. ytd is based on financial year and mtd is for current or latest month in dataset

[@ShaikJaheer-yh3bs]

Sir provide all tableau scanarios as well

[@itsall5180]

In scenario 2 rankx is not working. Too few arguments were passed to the rankx function. The minimum argument count for the function is 2.

[@ashokpandey5010]

I guess there's some conflicts in Rolling Month Sales Addition, It's not giving rolling sales accurately. I would like to request you to please check if this is correct or not.

[@datatutorials1]

It is correct

[@garimasingh-fi3wh]

Hi, why are you not getting any circular dependency error when you are sortiing the "Month " coloumn of the Calendar table with "Month Number" coloumn? I am getting this messgae and am not able to sort on this coulmn. Can you please help!!

[@swatilparikh]

Second Scenario is not working for me, still it is showing rank 1 to all Rank = RANKX(All(Sales_Data), CALCULATE(SUM(Sales_Data[Sales])))

[@oKUNDURUVYSHNAVI]

i think you can give order after giving order you can check once

[@poojagrpoojagr7236]

I had buyed material of interview questions but it is not opening

[@datatutorials1]

Download it first

[@swatilparikh]

Rolling12MonthsSales = CALCULATE( SUM('orders'[sales]), DATESINPERIOD('orders'[order_date], LASTDATE('orders'[order_date]), -12, MONTH) )

[@rishavshikary5034]

Subscribe karna jaruri hai ?

[@datatutorials1]

You will het notified with latest video and it will help me reach more peoples.

[@santoshkumbar8780]

How to contact u bro

[@datatutorials1]

Book a call, find link in description