TCS🔥Power BI Scenario based Interview Question & Answer 🔥SWITCH function inside FORMAT

No video

TCS🔥Power BI Scenario based Interview Question & Answer 🔥SWITCH function inside FORMAT

Рет қаралды 809

PowerBI Zone

Күн бұрын

Пікірлер: 12

@powerbizone 6 ай бұрын

Download this pbix for practice from below link : drive.google.com/file/d/1RhjrmblKLg7SYHZ68LS_rhnjDK295t3p/view?usp=sharing Iink for learning complete FORMAT DAX usecases : dax.guide/format/ You can send all your Interview Questions to yourpowerbizone@gmail.com ❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥

@madhusudhanreddyt2838 Ай бұрын

little simple way to avoid any confusion between the currency and percentage, we can use the below dax to create calculated column Output = FORMAT(Sheet1[Mixed], SWITCH(Sheet1[Type], "Decimal", "$00.00", "Percentage", "00.00%"))

@jamshedkhan850 6 ай бұрын

Really Informative..I will mail you the interview questions that I recently faced in Wipro and Mindtree

@powerbizone 6 ай бұрын

thnx a lot :)

@swatichoudhary9718 6 ай бұрын

Could you also state the difference between Import and Direct Query? Sometimes it is very confusing to understand.

@powerbizone 6 ай бұрын

thank you for your comment Swati ..As the name suggests Import means a copy of the data gets imported to your local Power BI desktop .While in direct query there is no role of local ,you are directly querying the underlying data source (lets say its Azure ,sql server ,oracle etc ).

@swatichoudhary9718 6 ай бұрын

@@powerbizone Could you please differentiate between all three modes of data connectivity and in what ways, these questions can be asked during interviews.

@powerbizone 6 ай бұрын

Sure.I will try to mke a video on this topic.As of now please go throgh the below link: radacad.com/directquery-live-connection-or-import-data-tough-decision