No video
Scenario: Running Total Without Date | Power BI Interview | Must Watch
Рет қаралды 10,923
Күн бұрынCodebasics Data Analyst Bootcamp Link: codebasics.io/...
Topmate Link to book call 1:1 - topmate.io/lea...
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
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
@vikassinghjayara510 2 ай бұрын
Another Solution for this question: CALCULATE([Total Sales], FILTER(ALL('Table 5'), ISONORAFTER('Table 5'[Product ID],MAX('Table 5'[Product ID]),DESC))) This function works like a filter whether specific conditions are satisfied for a row. If the condition are true , it says "Yes" for that row; otherwise, it return "No". Happy Learning! Thanks Shashank for making this playlist.
@atharwaborkar6778 Ай бұрын
this is not coming inside my measure don't know why can you please tell
@vishalsonawane.8905 7 ай бұрын
Hello All, use the below Optimize DAX(No need to Rank):---- Cumulative Total = CALCULATE( SUM('Sales 11'[Total_Sales]), FILTER( ALL('Sales 11'), 'Sales 11'[Product ID]
@rahulmehla2014 2 ай бұрын
Another solution : Running Sales Window = CALCULATE( [Sales Total], WINDOW( 1,ABS, 0,REL, ALLSELECTED('Sample Running Sales'[Product ID]) ) )
@Supratim-jb2tk 7 ай бұрын
Hi Shashank, I have a practical question here, what would be the practical implication of such a scenario? No. 1, Could we only do this in either ascending or descending order of Ranking? No. 2, why the product ID column could not be used as the basis for Cumulative total? They are in order here, just like a surrogate key.
@Sirigineedi_Navann Жыл бұрын
Simply superb 🎉🎉🎉🎉
@learnwidgiggs Жыл бұрын
Thanks a lot 😊
@Supriyakrish Жыл бұрын
Hi Shashank Thank you for your time to help us. I have an interview question asked by my interviewer, please help me find an answer How can we find the amount of space used by customers? Usage metrics helps us to find total no. Of customers and views but not the space used by them. Please make a short video on this . Thanks a lot 🙏
@learnwidgiggs Жыл бұрын
Amount of space means?
@Supriyakrish Жыл бұрын
@@learnwidgiggsI have no idea May be storage space they meant
@Rajisatishworld Жыл бұрын
Hi we use same process by using ranking as a measure instead of a calculated column. in such case how the cummulative dax should be? please help
@nitingupta20031 Жыл бұрын
Hi Shashank, I am using the same method that you described, however i getting the error. Syntax "M_Cumulative Total = CALCULATE([M_Total Sales],FILTER(ALL(Sheet1),[M_Rank]
@millar2255 Жыл бұрын
I think u used a measure instead of a new column while creating "Ranking " check that
@Akshay_Petkar Жыл бұрын
Hi, why we create ranking measure for this? we can use product_id for a filter expression.
@tushargogiya4017 Жыл бұрын
yeah its working
@vikramraju3289 Жыл бұрын
Hi bro..i am from Non IT background...by learning SQL,SSIS & POWER BI,DWH Can i get job in IT industry...
@learnwidgiggs Жыл бұрын
Yes brother
@rohitbansode9813 Жыл бұрын
What power bi projects could be the best to grab the attention of recruiter Please suggest some In which Every part of power bi is covered and get the job
@rohitbansode9813 Жыл бұрын
Hii , I have one question, after creating dashboard connected with database of real time data which changes frequently, so as the data changes does the result on dashboard changes simultaneously or we have to do it everytime
@learnwidgiggs Жыл бұрын
If it is in direct query then you will see the changes simultaneously.
@rajeshn5006 Жыл бұрын
thanks man
@learnwidgiggs Жыл бұрын
Happy to help.
@bhavnachalise Ай бұрын
Hi Sir, Is it possible if there is no data after filtering from slicer for a table, then that table goes away and another table is visible in place of first table.
@atharwaborkar6778 Ай бұрын
@vikramraju3289 Жыл бұрын
Wheather your interview questions playlist will help to crack the interview of 3 to 4 years experience in power bi .... Please reply me
@learnwidgiggs Жыл бұрын
Yes, it will.
@vikramraju3289 Жыл бұрын
@@learnwidgiggs thanks a lot for replying...me brother..
@millar2255 Жыл бұрын
Hi bro, i have a one question what if my order of product id should not change and need calculate running sum??
@chinmayamuduli468 Жыл бұрын
Hi Sashank now a days ai tools and co pilot are coming in powerbi . Are powerbi developer jobs are not in danger ?
@learnwidgiggs Жыл бұрын
I will be uploading a video on this..on coming Monday..stay tuned.
@chinmayamuduli468 Жыл бұрын
Okay thanks
@susantikamaity2210 11 ай бұрын
Can we use window function in this scenario?
@learnwidgiggs 11 ай бұрын
Yes, you can try it out.
@susantikamaity2210 11 ай бұрын
@@learnwidgiggs Thanks it's working. DAX =CALCULATE([total sal],WINDOW(1,ABS,0,REL,ALLSELECTED('scenario 37'[emp id],'scenario 37'[rank]),ORDERBY('scenario 37'[rank])))
@learnwidgiggs 11 ай бұрын
@@susantikamaity2210 Great 👍
Fabiosa Best Lifehacks
Рет қаралды 21 МЛН
LearnWidGiggs
Рет қаралды 23 М.
KPH Trainings (English)
Рет қаралды 5 М.
Satyajit Pattnaik
Рет қаралды 13 М.