Substring in DAX How to get Part of String Field in Power BI Using DAX Expression

Substring is one of the most common functions in many languages, However, there is no such function in DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from "Reza Rad", if I want to get the start starting from index 2, for 4 characters, it should return "za R". Considering that the first character is index 0. Let's see how this is possible.
Download the code and Power BI file from my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

[rajdev]

Hey RAD, how could i substring characters from 0th position to a token(delimiter), any suggestions

[pchidambaram]

Hey RAD, how can we have a substring starting after @ (domain name)