Frequently Asked | Scenario to calculate RUNNING TOTAL

Frequently Asked | Scenario to calculate RUNNING TOTAL | Power BI Interview

Рет қаралды 21,881

Жыл бұрын

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

Пікірлер: 58

@lookingforbusiness5662 Жыл бұрын

Running Total = var slicer = SELECTEDVALUE('Date'[year]) var Total = CALCULATE(SUM(financials[COGS]),'Date'[year]

@rajatdixit11 Жыл бұрын

Excellent real-time based scenario explained in such simple way! Love your work..Keep going like this.

@learnwidgiggs Жыл бұрын

Thanks a ton

@Regans5677 11 ай бұрын

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.

@learnwidgiggs 11 ай бұрын

Glad it helped

@vinodkumarhs4000 6 ай бұрын

Will try tomorrow for my working purpose

@hellboygamng.874 Жыл бұрын

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 !

@learnwidgiggs Жыл бұрын

plz watch this playlist on DAX videos: kzfaq.info/sun/PLk-s1KYuT-PnTC_JnuLsZvCnhdUgd5puZ

@hellboygamng.874 Жыл бұрын

Completed . Actually asking about tutorial series and concept based as well. If possible please make videos on that.

@learnwidgiggs Жыл бұрын

ok, will plan

@hellboygamng.874 Жыл бұрын

Thanks so much!

@JayeshTatipamul Жыл бұрын

Very Useful Video. Thanks for sharing.

@learnwidgiggs Жыл бұрын

My pleasure 😊

@nandinireddy2455 Жыл бұрын

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

@vaibhavwani3922 Ай бұрын

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

@Abeer_777 Ай бұрын

Hi, your video is helpful but you should provide data set as well for practice

@virtuallyapplied3275 Ай бұрын

can we use TotalYTD(),TotalMTD(),TotalQTD() for thi s?

@anweshkp6231 Жыл бұрын

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.

@themightyvk 11 ай бұрын

Could you provide any link to all, all expect and all selected tutorial

@Travel.is_fun 3 ай бұрын

Need a video on bookmarks - Data,Display,All Visuals,current page, selected visuals usage in real life.

@AshishAnand-ry1kt 10 күн бұрын

datesinperios will work??? if not then why??

@sathyamanohar1894 Жыл бұрын

We can use datesytd or totalytd also right to calculate running total ?

@learnwidgiggs Жыл бұрын

But that would be specific to Year wise, will not be dynamic I believe.

@kousralakkireddy943 11 ай бұрын

We can achieve this by using totalytd also

@hardikthakkar3331 Жыл бұрын

TotalYTD function will also do the same job

@learnwidgiggs Жыл бұрын

It would work here but if you will go to a lower granularity, it won't.

@madhusudhanreddyt2838 Жыл бұрын

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

@gprstex 11 ай бұрын

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

@syedabaduruunnisa3099 Жыл бұрын

We can use dateinperiod dax function also right

@learnwidgiggs Жыл бұрын

I don't think it will work here

@nagavenisiri4370 Жыл бұрын

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

@learnwidgiggs Жыл бұрын

Yess

@nagavenisiri4370 Жыл бұрын

@@learnwidgiggs thanku

@themightyvk 10 ай бұрын

CALCULATE([Total_Sales],CalendarDate[Date]

@Chidu-Goudru Жыл бұрын

Thank you bro...iwithout year running total how will calculate bro

@learnwidgiggs Жыл бұрын

Will upload a video soon

@ArchnaVijay Жыл бұрын

new subscriber

@sourabhpatel3834 7 ай бұрын

Why are you not using directly =CALCULATE ([Total Sales] , dimdate [date]

@learnwidgiggs 7 ай бұрын

Performance of the DAX query will not be good.

@sourabhpatel3834 7 ай бұрын

@@learnwidgiggs but using filter will consume more time naa?

@learnwidgiggs 7 ай бұрын

@@sourabhpatel3834 no

@abhishekbagul3873 Жыл бұрын

Sir , as a power bi developer, will SSIS require or not for the interview point of view?

@learnwidgiggs Жыл бұрын

Mostly not asked in the interview but required in the job description so one can put on resume

@longliveindia1637 Жыл бұрын

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

@learnwidgiggs Жыл бұрын

Nhi hoga, mere hisaab se.

@longliveindia1637 Жыл бұрын

@@learnwidgiggs power bi ke saath sql bgi zaruri hai

@learnwidgiggs Жыл бұрын

haa bilkul

@longliveindia1637 Жыл бұрын

@@learnwidgiggs aap class provide karate ho power bi aur sql ki with prictical knokedge

@learnwidgiggs Жыл бұрын

As of now, nhi

@LittleKrishna17218 Жыл бұрын

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]

@learnwidgiggs Жыл бұрын

Yes it should work but its not an optimized way

@nagavenisiri4370 Жыл бұрын

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

@learnwidgiggs Жыл бұрын

Yes