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

[@Dheeraj-k6m]

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

[@ashish90702]

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

[@biswadeepsahoo]

Your explanation skill is excellent

[@yamin800]

Please add more videos like this, loved it

[@shambavivusirikala1355]

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

[@akshayyelwande-j7j]

Very Useful content,Thank You Sir.

[@datatutorials1]

Keep watching

[@ramshataqdees5570]

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

[@Learnings-1990]

You are awesome 😎👍

[@beneficial4u572]

Subscribed, Please keep on posting

[@datatutorials1]

Thanks

[@emilyamalkin4367]

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

[@riasingh11]

what great learning i've had! 🌟

[@amalayadav7406]

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

[@aruchique]

Very useful videos!

[@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

[@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?

[@vishwassharma3312]

Kindly Upload more such type videos?

[@shivang18]

For third scenario, we could have used YEARTD function

[@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.

[@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

[@himanshubasra4451]

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

[@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!!

[@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.

[@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

[@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

[@ShaikJaheer-yh3bs]

Sir provide all tableau scanarios as well

[@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.

[@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!"

[@santoshkumbar8780]

How to contact u bro

[@datatutorials1]

Book a call, find link in description