Power bi scenario based interview QnA - Using PATHITEM & SUBSTITUTE DAX

#powerbi #powerbiinterviewquestions #powerbidaxfunction #powerbizone
In todays power bi interview question we see a tricky scenario where the interviewer wants to evaluate your knowledge based on two DAX functions namely SUBSTITUTE() and PATHITEM().
Do watch the complete video for a complete unerstanding.
🔥🔥🔥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 ...
👉23.Substitute dax to get rid of Numbers from Alphanumeric column:
• 🔥Power bi DAX intervie...
👉24.Substitute dax to derive Numbers from Alphanumeric column:
• Substitute dax to deri...
🔥🔥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 : [e-mail]

[@saltpepper9062]

Excellent..top notch content

[@powerbizone]

thnx a lot :)

[@gracehu4111]

Very helpful and clear explanation! Thank you very much. Subscribed.

[@powerbizone]

Glad you liked it .Thnx fr the subscription :)