🔥Power bi DAX interview Question & Answer 🔥: Using Substitute dax to get rid of numbers

#powerbideveloper #powerbiinterviewquestions
This power bi interview Question was asked in many companies including Wells Fargo .It uses the dax function Substitute.
The substitute dax Replaces existing text with new text in a text string .
Syntax :SUBSTITUTE(text, old_text, new_text, instance_num)
Download the pbix file from: https://drive.google.com/file/d/1WjqP4HLM9jAtQ5Dwmnrl236n5j_uojjS/view?usp=sharing

🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉1.SamePeriodLastYear with Example: https://www.youtube.com/watch?v=WU9pJyyCOJE
👉2.How to Calculate Running Totals: https://www.youtube.com/watch?v=1o9E7NV1uP4
👉3.Duplicate Vs Reference : https://youtu.be/n7XzkVH3Ij0
👉4.Merge Vs Append: https://youtu.be/ZfmdKRq2A4Y
👉5.Calculate Function in DAX Power BI: https://youtu.be/mPhpG8VYDlI
👉6.Filter Function in Power BI: https://youtu.be/5wKvfL6rfmY
👉7.Row Vs Filter Context: https://youtu.be/AKyijOTkMnw
👉8.ALL DAX Function: https://youtu.be/co8s79zVS7E
👉9.ALL Vs ALLSELECTED : https://youtu.be/bv7Yho9DX0c
👉10.ALL Vs ALLSELECTED VS ALLEXCEPT : https://youtu.be/aVVua4fG1V0
👉11.ALL Vs REMOVEFILTERS : https://youtu.be/BPo7SzJXb0w
👉12.TOPN Dax Usage : https://youtu.be/UEjgu5d607Q
👉13.Summarize Dax Function in Power BI: https://youtu.be/4W4eENnFi24
👉14.Summarize Vs Summarizecolumn :https://youtu.be/ugVyoTwReag
👉15.Calendar Vs CalendarAuto : https://www.youtube.com/watch?v=pIIk42R4ex4
👉16.How to create a date table in Power BI : https://youtu.be/H8BVh6s6egU
👉17.How to calculate Running total for date values in Power BI
https://youtu.be/NBGGHdKxupk
👉18.How to default your slicer to current year/Month (Method 1 using custom visual) : https://youtu.be/o-gr3XgU1mg
👉18.How to calculate running total in power bi for non date values: https://youtu.be/85sKPSnc_GE
👉19.Usage of datediff in Power BI: https://youtu.be/nhvbGRAk2tk
👉20.Isblank() Vs Isempty : https://youtu.be/OItCmUrklhk
👉21.Power BI Scenario based Qn A :https://youtu.be/vkdNS3hEBiA
👉22.Power BI Interview Question (SWITCH function in FORMAT): https://youtu.be/9G3zebtJZ4k
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
https://powerbizone.com/category/articles/
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Mail your Queries at : yourpowerbizone@gmail.com
Download the pbix file from :
https://drive.google.com/file/d/1RhjrmblKLg7SYHZ68LS_rhnjDK295t3p/view?usp=sharing

Mail your Qn A to yourpowerbizone@gmail.com

Видео 🔥Power bi DAX interview Question & Answer 🔥: Using Substitute dax to get rid of numbers канала PowerBI Zone