Power BI Scenario based Interview Question: Format negative numbers in Red Brackets
Vložit
- čas přidán 21. 03. 2024
- In this Power BI Scenario we see how to format a negative number withiin brackets .This is one of the most commonly asked Power BI Interview Question .To Answer this you need to be aware of the FORMAT Function in Power BI .
Also see the below link for detailed explanation on FORMAT :
dax.guide/format/
#powerbi #powerbi_training #powerbipro #powerbizone
🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉1.SamePeriodLastYear with Example: • difference between par...
👉2.How to Calculate Running Totals: • How to calculate runni...
👉3.Duplicate Vs Reference : • power bi difference be...
👉4.Merge Vs Append: • power bi difference be...
👉5.Calculate Function in DAX Power BI: • What is Calculate Func...
👉6.Filter Function in Power BI: • Filter Function in Pow...
👉7.Row Vs Filter Context: • Row Context Vs Filter ...
👉8.ALL DAX Function: • How to use ALL Dax Fun...
👉9.ALL Vs ALLSELECTED : • allselected dax|all vs...
👉10.ALL Vs ALLSELECTED VS ALLEXCEPT : • All Vs AllSelected Vs ...
👉11.ALL Vs REMOVEFILTERS : • ALL Vs REMOVEFILTERS D...
👉12.TOPN Dax Usage : • TOPN Dax | How to use ...
👉13.Summarize Dax Function in Power BI: • summarize dax | How to...
👉14.Summarize Vs Summarizecolumn : • summarize vs summarize...
👉15.Calendar Vs CalendarAuto : • Calendar Vs Calendar A...
👉16.How to create a date table in Power BI : • how to create a date t...
👉17.How to calculate Running total for date values in Power BI
• How to calculate Runni...
👉18.How to default your slicer to current year/Month (Method 1 using custom visual) : • How to Set Default Sli...
👉18.How to calculate running total in power bi for non date values: • Running Total in Power...
👉19.Usage of datediff in Power BI: • Power BI datediff dax ...
👉20.Isblank() Vs Isempty : • Power BI ISBlank DAX F...
👉21.Power BI Scenario based Qn A : • Power bi scenario base...
👉22.Power BI Interview Question (SWITCH function in FORMAT): • TCS🔥Power BI Scenario ...
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
powerbizone.com/category/arti...
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Mail your Queries at : yourpowerbizone@gmail.com
Chapters:
0:20 :Scenario Explanation
1:31 :Usgae of FORMAT Dax
2:03 :Understanding sections under FORMAT
3:03 :Specifying Negative format
3:46 :Conditional Formatting
4:46 :Trick in conditional Formating for -ve numbers
5:55 :Subscribe
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 !🔥🔥
Another great and simple explanation with clearcut example..thnx
Pure simple knowledge on dax. Please bro continue to create such gems ❤
thnx bro for the kind words! :)
loving your videos man. please keep posting more of such content
Thank you so much Aman .Will keep them coming :)
Very nice.
This may very helpful in my project as i am working on finance project.
We can use min and max word rather than putting high or low values.
Bcz i am using this thing.
Yep..agreed and glad you are using this in your project :)
hi sir, can you create one video about how to create table from another table using DAX. for ex: table 1 has around 15 columns and table 2 has 8 columns, i wants to create a table 3 from table 1 to bring only few required columns and emp id's matching from table 2
Thnx for the suggestion Prabhu ..Was this question asked in any nterview .If yes do comment the name of the company and i will surely make video on this topic.By the way do you need selected columns from table 1 and only matchig emp id from tabe 2? Cant you acheive this using left join ?
Promo'SM 🙌
:)