Frequently Asked | Scenario to calculate RUNNING TOTAL | Power BI Interview
Vložit
- čas přidán 4. 09. 2022
- 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
Running Total =
var slicer = SELECTEDVALUE('Date'[year])
var Total = CALCULATE(SUM(financials[COGS]),'Date'[year]
Excellent real-time based scenario explained in such simple way! Love your work..Keep going like this.
Thanks a ton
Will try tomorrow for my working purpose
Thanks a lot for this DAX,after im tried alot but with single dax my output came same as you given,i tried for different data to calculate cummulative.its workout for all.thanks a lot for your knowledge and hardwork.
Glad it helped
Very Useful Video. Thanks for sharing.
My pleasure 😊
Then how does max function work here for the current filter context.. we are considering the entire calendar date table right.. max(date) From entire table would return last available year right
Hi, your video is helpful but you should provide data set as well for practice
can you please make videos on dax ? I'm falling in love with your content. No bakwas, to the point, Crisp and clear and also easy to grab. Thanks so much !
plz watch this playlist on DAX videos: czcams.com/play/PLk-s1KYuT-PnTC_JnuLsZvCnhdUgd5puZ.html
Completed . Actually asking about tutorial series and concept based as well. If possible please make videos on that.
ok, will plan
Thanks so much!
Could you provide any link to all, all expect and all selected tutorial
I've data related to actuals and forecast values. Wanted to calculate cumulative total where actual and forecast values will show but on same line. I've columns where it is showing status of values as actual n forecast. And that line should identify actual n forecast with different colour
Need a video on bookmarks - Data,Display,All Visuals,current page, selected visuals usage in real life.
All(Calendar_table) should have ignored year filter context and returned all dates for all years correct?
It should be 2665 for every year.
I know I'm wrong but that's how I understood All function, please explain me where I'm wrong.
can we use TotalYTD(),TotalMTD(),TotalQTD() for thi s?
We can achieve this by using totalytd also
datesinperios will work??? if not then why??
new subscriber
CALCULATE([Total_Sales],CalendarDate[Date]
We can use datesytd or totalytd also right to calculate running total ?
But that would be specific to Year wise, will not be dynamic I believe.
TotalYTD function will also do the same job
It would work here but if you will go to a lower granularity, it won't.
Totalytd function is also going to do the same job but it is going to calculate upto that year last date...for the next year it is going to reset...if you want to calculate the cumulative total for the year to date then we can go with totalytd function
We can use dateinperiod dax function also right
I don't think it will work here
Thank you bro...iwithout year running total how will calculate bro
Will upload a video soon
@LearnWidGiggs bhai iam completely by bcom and having 6 years of experience in US Healthcare
Can we move into power bi with atleast 3 years of experience in total of 6 years.
Yes
Sir , as a power bi developer, will SSIS require or not for the interview point of view?
Mostly not asked in the interview but required in the job description so one can put on resume
Date Name Sales
1-Jul a 200
1-Jul c 200
2-Jul a 100
2-Jul b 200
2-Jul c 200
3-Jul b 100
3-Jul c 200
4-Jul a 200
4-Jul c 100
5-Jul a 200
5-Jul b 100
5-Jul c 200
I have this simple table, here total of sales is 2000, so I want to keep 2000 value unchanged when I select a, b, or c through slicer. As a example if I select "a" the value given is 1700, because it is not taking 3-July total value for final calculation, Pls help me
exactly the same solution I am after
Why are you not using directly
=CALCULATE ([Total Sales] , dimdate [date]
Performance of the DAX query will not be good.
@@learnwidgiggs but using filter will consume more time naa?
@@sourabhpatel3834 no
Bhai b.a gradute hu 8 saal ka experience hai non it ka agar power bi ssekhta hu toh interview call aaeyenge b.a barrier toh nahi hoga
Nhi hoga, mere hisaab se.
@@learnwidgiggs power bi ke saath sql bgi zaruri hai
haa bilkul
@@learnwidgiggs aap class provide karate ho power bi aur sql ki with prictical knokedge
As of now, nhi
all videos are very useful
thanks for this
for this, i used a different method
i think this will also work
VAR SelectedYear = MAX(CalendarDim[Date])
RETURN
CALCULATE(SUM(Fact[Sales]),CalendarDim[Date]
Yes it should work but its not an optimized way
@LearnWidGiggs bhai iam completely by bcom and having 6 years of experience in US Healthcare
Can we move into power bi with atleast 3 years of experience in total of 6 years.
Yess
@@learnwidgiggs thanku
Can we use total ytd function here?
In the discussed scenario, it should also work.
@@learnwidgiggs discussed scnerio?