Scenario: Calculate TOTALYTD in DIRECT Query Connection | Power BI Interview | MUST WATCH

Topmate Link to book session 1:1 - topmate.io/learnwidgiggs
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / shashank_nikumbh26
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
#powerbiinterview
#learnwidgiggs

[@sourabhpatel3834]

Use ALL in filter function while writing table name If you dont use it won't give u desire results (use matrix visual to see)

[@djenral6153]

You are fantastic..!

[@hey_its_anoy]

Thank you very much sir 🙏 Aapka padhane ka tarika owsm hai... Specially dax function 🔥🙌

[@learnwidgiggs]

Welcome 😊

[@user-gq6cg3ls7f]

This is great, I have a question: when to use TOTALYTD and CALCULATE functions since both are producing the same results 400. The first one TOTALYTD is more easy but the second one CALCULATE is more lengthy. If you have a video, please share.

[@qayyumkadri2138]

TotalYTD works in direct query mode. I have used it.

[@madhusudhanreddyt2838]

if you have a dedicated date dimension table in your model, then the direct query mode will work to perform TOTALYTD and other time intelligence function...if you don't have a date dimension table in the model, then time intelligence functions will not work in the direct query mode

[@letsexplore0075]

Great video! though Consider adding the Data set (Mandatorily) for practicing purpose and PBIX file (Optional)

[@sunilkumar-uo8so]

Here is a problem when you use( total YTD with date ) then get all sub total including all years in a table 2 when you used second rule then you get current year total.

[@vikassinghjayara510]

Very informative video.

[@learnwidgiggs]

Thank you 😊

[@chandrakanthlaghishetty646]

could you please explain how the max works here dynamically, I mean how it is filtering jan=1000,feb=jan(1000)+feb month data

[@djenral6153]

OSM

[@sushantchoigale9896]

Thank you very much Sir🙏.. Sir please also provide the datasets that you have use in the videos🙏🙏. For doing practice.

[@learnwidgiggs]

Welcome, dataset yar usable form me nhi ..esliye de nhi paunga..you can create the same by watching from the video..it is very small with 8-10 records

[@sushantchoigale9896]

@@learnwidgiggs ok sir👍

[@shardulbhilkar1455]

How to calculate PY without using same period last year because it is not supported in direct query

[@ushakiran6001]

Hai sir awesome explanation very clear 😊 I have one question sir is there PBI openings now

[@learnwidgiggs]

Yeah vacancies are coming but limited

[@AYuvaraj-ju2qh]

Hello shashnk, Your videos are very helpfull to prepare power bi interviews. i want you to clarify one thing, in direct query time intelligence functions are working but is there any performance issues arrives when using large data sets. kindly clarifiy.

[@madhusudhanreddyt2838]

if you have a dedicated date dimension table in your model, then the direct query mode will work to perform TOTALYTD and other time intelligence function...if you don't have a date dimension table in the model, then time intelligence functions will not work in the direct query mode

[@mayurijagtap9748]

Sir .... I have one question....i have one year experience can i switch my this job is there chances for call frequency as a power Bi devloper.....

[@learnwidgiggs]

Wait for 6 more months

[@shubhammalode4733]

Sir, Your teaching skills are Awesome...It's request to you plz make Complete Series on DAX ...🙂🙂

[@learnwidgiggs]

Will plan!

[@enjystory464]

Why we need totalytd and what it mean sir ?

[@learnwidgiggs]

Total year to date ...Generally requirement is there to calculate year to date sales...in real time projects

[@mahelakakhan1145]

Hey do you have power BI MCQ ?

[@learnwidgiggs]

No, not yet

[@vikassinghjayara510]

I got a selection but the project has not been allocated yet. What type of question was asked in the client project round?

[@learnwidgiggs]

Which company you got selected?

[@vikassinghjayara510]

@@learnwidgiggs Tech Mahindra and Teleperformance

[@learnwidgiggs]

@@vikassinghjayara510 Congratulations brother ❤️

[@vikassinghjayara510]

@@learnwidgiggs thank you so much sir. Any idea what would be in the client project round

[@learnwidgiggs]

@@vikassinghjayara510 It will be very easy..don't worry..Just revise everything as you did before the normal interviews.

[@ArifKhan-qo9jw]

Hi, Thank for sharing this, however we can archive same result with " Calculate{Total Sale} Filter (Calendar_Table), Calendar_Table Year = 2022) I think so i have not tried yet this is also correct way to locate particular year amount.

[@learnwidgiggs]

You have hard-coded it, so it won't work...we have to make it dynamic

[@shreyasvibhute3102]

@@learnwidgiggs At last past of dax expression.......instead of Max of calendar tables date can we use TODAY Function so it will return total sales till today...?

[@learnwidgiggs]

@@shreyasvibhute3102 I'm not sure because today is also a time function. So it is quite possible that it won't work.