Client Round | Scenario based on EARLIER() | 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

[@rithwikmr999]

index = VAR _currentModel = tableName['Apple Phone'] VAR _modelGroup = FILTER(tableName, tableName['Apple Phone'] = _currentModel) RETURN RANKX(_modelGroup, tableName[Supplier],,ASC) an alternate way to do the same thing.

[@learnwidgiggs]

Thanks for the alternate way.

[@kishorpatil8460]

Nice, Power query also do the same,

[@RISHIYADAVMOTIVATION]

Measure = CALCULATE(COUNT('Table'[apple]),WINDOW ( 1, ABS, 0, REL,ALLSELECTED('Table'[apple],'Table'[supplier]),ORDERBY('Table'[apple],asc),,PARTITIONBY([apple]) )) an alternate way to do the same thing.

[@ravireddy270]

Your explanation nd ur way of teach is sooo nice

[@learnwidgiggs]

Thank you 🙂

[@tushargogiya4017]

i dont know why but earlier function is not supporting in my desktop app earlier cant able to access row context

[@anjaligoorha3180]

not able understand this earlier function

[@susantikamaity2210]

index = ROWNUMBER(ALL('scenario 23'),ORDERBY('scenario 23'[country]),DEFAULT,PARTITIONBY('scenario 23'[phone]))

[@sourabhpatel3834]

Dont use ALL it is unnecessary , partitionby already defines scope of the row number calculation based on the model

[@bloodrain3589]

In power query we can create with the help of a group by (all rows ) and without expanding and create custom column for index and remove other columns and expand custom column we will get same

[@Rajkumar-kj1vx]

Hi.. Thanks for the new approach. But I am getting the same index value for all the rows belonging to same iPhone like 111,2222 respective to the order. am I missing something..?

[@learnwidgiggs]

Thanks for checking

[@bloodrain3589]

@@Rajkumar-kj1vx Group by product with all rows and create custom column with (table.addindexcolumn) and remove the other 2 columns and expand the custom column

[@AYuvaraj-ju2qh]

Hello shashank, If you have same product and same supplier in table ,the result should be not from 1 and grouping also not given this kind of result properly.

[@guruprakashram2868]

Index = RANKX( ALLEXCEPT(YourTable, YourTable[Apple Phone]), YourTable[Supplier], , ASC, Dense )

[@sourabhpatel3834]

=ROWNUMBER( ORDERBY(supplier) , PARTITIONBY(model))

[@shreyasvibhute3102]

Is it working

[@sourabhpatel3834]

@@shreyasvibhute3102 yes it will work

[@vishalsonawane.8905]

Great. Yes Its working i have try now

[@PiyushKumar-tv6dr]

what is the first argument here? the above code doesn't work

[@TarunDhimanOfficial]

IndexColumn = RANKX( FILTER( 'Table 4', EARLIER('Table 4'[Apple Iphone]) = 'Table 4'[Apple Iphone] ), 'Table 4'[Supplier], , ASC, Dense ) Shashank! This might give the similar answer also

[@learnwidgiggs]

Plz try once practically..if it gives the same result then it's great 👍

[@TarunDhimanOfficial]

@@learnwidgiggs It is working fine.

[@kamalgautam3665]

Hi, what if the suppliers are not in asc/desc order, and still we want index in order..how to solve this?

[@learnwidgiggs]

I believe in that scenario also the discussed DAX code should work

[@rahulwankhede8228]

What if the iran is there

[@dileepkv3124]

Hello Shashank..apart from this being an interview question, what is the purpose of this index? I mean i didn;t understand why this is required or rather what purpose does it serve?

[@learnwidgiggs]

In real life scenarios also it is quite handy sometimes.

[@krantikumar894]

In ''Apple Phone'' column we have only two categories, but if multiple categories then wt is the solution like iphone X, 10,11,12,13 and 14.

[@learnwidgiggs]

It would work correct I believe

[@namitamehta-sb9hf]

Hi Shashank, What if the suppliers are not in asc order, and still we want index in order. `

[@learnwidgiggs]

I believe in that scenario also the discussed DAX code should work

[@HappyAnalysing]

The solution only work if the if the suppliers are in asc order. Otherwise, the calculated index column will give values based on suppliers ascending order, hence your index column values will be in random order in each "Apple Phone" section.

[@hey_its_anoy]

hii shashank sir... like in power bi... is null count in inner join in SQL? i m confused in that perticular pbi scenario and Sql scenario

[@learnwidgiggs]

Null is equal to null in power bi but in sql null is ignored during inner join

[@hey_its_anoy]

@@learnwidgiggs yes sir. Thank you 💎🙏

[@sapnataneja_88]

I am getting error with same code Indexing_to_allproducts_Subcategory = CALCULATE(COUNT(Sales_Data[Product Sub Category]), FILTER(Sales_Data,EARLIER(Sales_Data[Product Category]=Sales_Data[Product Category] && EARLIER(Sales_Data[Product Sub Category]>=Sales_Data[Product Sub Category])))) can you help me to find solution

[@sapnataneja_88]

error is Cannot nest EARLIER/EARLIEST functions.