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.
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.
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.
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!!
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.
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!"
![Twenty One Pilots - “The Line” (from Arcane Season 2) [Official Music Video]](http://i.ytimg.com/vi/E2Rj2gQAyPA/mqdefault.jpg)
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.
Refer us also bro. That will help any one of us in this community. Finding a powerbi job's now a days very tough.
You are champion and I have subscribed as part of that 80%
Thanks you bro
You are simply superb, thanks a ton for helping the unknown like me unconditionally.
Grateful.🙏
Your explanation skill is excellent
Please add more videos like this, loved it
Thanku for ur informative videos...lot of knowledge to gain
Thanks a lot for this video 👍👍
Please provide more such interview related Power BI videos
You are awesome 😎👍
Very Useful content,Thank You Sir.
Keep watching
Thank you! I love your videos you your presentation style 👍🏻👍🏻👍🏻👍🏻👍🏻❤
Very useful videos!
what great learning i've had! 🌟
thanks alot....
please make more vdos on powerbi scenario based interview questions
Subscribed, Please keep on posting
Thanks
Nice explanation Sir. Please post Power BI course videos on all the topics.
Thanks for sharing data and please make video on Dynamic Slicers on Different Date because In TCS interview they ask me the Question.
Can you please elaborate the question?
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.
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.
Hi Sir,
In scenario 1, we can take 'Today' function instead of 'Max(calender(date))' function right? in Datesinperiod function.
Yes if you are working with real time data
Kindly Upload more such type videos?
For third scenario, we could have used YEARTD function
Sir .
Is your play list enough to give an interview on power bi with 2 years of experience?
Whey cant we use Dateinperiod or totalytd in scenario 3 any idea?
Can't we use direct functions for running total like YTD, MTD type ?
How will you use these functions here. ytd is based on financial year and mtd is for current or latest month in dataset
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.
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!!
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])))
i think you can give order after giving order you can check once
Sir provide all tableau scanarios as well
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.
It is correct
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!"
I had buyed material of interview questions but it is not opening
Download it first
Rolling12MonthsSales =
CALCULATE(
SUM('orders'[sales]),
DATESINPERIOD('orders'[order_date], LASTDATE('orders'[order_date]), -12, MONTH)
)
Subscribe karna jaruri hai ?
You will het notified with latest video and it will help me reach more peoples.
How to contact u bro
Book a call, find link in description