POWER BI DAX INTERVIEW Q&A: How to Rig an Interview

POWER BI DAX INTERVIEW Q&A: How to Rig an Interview | Power BI

Рет қаралды 5,602

Pivotalstats

Күн бұрын

Пікірлер: 26

@arunbagh-db4lp Ай бұрын

Hi, this is my first time visiting this channel. I understand DAX well. You are doing a great job.😘

@pivotalstats Ай бұрын

Welcome aboard! :)

@user-ll4ze9bz3r 6 күн бұрын

GREAT!

@pivotalstats 6 күн бұрын

Thanks :)

@shubhamgupta9323 Ай бұрын

please make video on calculate and calculate table functions in dax

@pivotalstats Ай бұрын

Hi, you can checkout the below DAX masterclass video, where I have covered Calculate and many other important DAX function. However I have noted it down & will cover CalculateTable in a future video. Thanks! kzfaq.info/get/bejne/athzbLKonJzSYIk.html

@jigneshchawda2436 11 ай бұрын

Great Playlist! Can you add more such videos and cover the mentioned topics please? and also waiting for the next project to follow along.. Thankyou!

@pivotalstats 11 ай бұрын

Yes, sure. Thanks for watching!

@gustavocarrillo9058 5 ай бұрын

Great content in the video, thank you! I do, would like the examples between calculate vs calculate table to understand the differences. Im just starting with powerbi so it is confusing

@pivotalstats 5 ай бұрын

Check out my other video on Dax masterclass, it should be a good starting point (link below) kzfaq.info/get/bejne/athzbLKonJzSYIk.html

@praveenguduru160 6 ай бұрын

great job man thank u somuch

@pivotalstats 6 ай бұрын

You're welcome!

@krashvillenadia 9 ай бұрын

Thank you for the clip. By the way, Sajit Simon is handsome 😅

@pivotalstats 9 ай бұрын

Thanks 😄

@balajiroyal8668 9 ай бұрын

Pls cover more topics with multiple examples

@pivotalstats 9 ай бұрын

Sure! I have created a DAX masterclass video, where all essential DAX are covered with examples. Check that out if you like (link below) kzfaq.info/get/bejne/athzbLKonJzSYIk.html

@shubhamgupta9323 3 ай бұрын

i tried using rankx in a measure but for me all the values in rank are coming came when i used in a table visual once i apply all function then it removes the filter at any column level in particular table. please tell. How for you values are showing different in measure does it handles differently in column level and measure level

@pivotalstats 3 ай бұрын

RANKX in a measure can give you different results because it is calculated based on filter / row context applied to each visual, however in Calculated Column each row's rank is calculated independently. Check out below 2 videos which will give you a better understanding of how to structure your DAX: DAX Masterclass - kzfaq.info/get/bejne/athzbLKonJzSYIk.htmlsi=ikQ7f8jsRUn2XzMQ 2 Pillars of DAX Structuring: kzfaq.info/get/bejne/a9ipqLSoktWWoWg.htmlsi=rXvmdYs_fgEwSU4W

@nairobi203 5 ай бұрын

Instead of using Switch, would it not be better to create a table and to relate them?

@pivotalstats 5 ай бұрын

Hi, Yes it depends on your data. If the number of items which needs to be labeled are very less & will remain static, for example, in this case it was only 5 items, then I would prefer Switch because its easier to implement. However if number of items are substantially large or it keeps on changing then I would definitely use the method that you suggested. Hope this helps!

@nairobi203 5 ай бұрын

@@pivotalstats thanks for the explanation. All the best.