Forum Discussion

Obrycki's avatar
Obrycki
Regular Visitor
6 years ago
Solved

DAX: SUBSTITUE Instance not dynamic

In Power BI Desktop I'm attempting to dynamically determine the last instance of a character and SUBSTITUTE that character with another. The following DAX formula appears to work in Excel but does no...
  • lbendlin's avatar
    lbendlin
    6 years ago

    Replace your underscore "_"  with a pipe "|"  and use the PATH functions.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Replace your underscore "_"  with a pipe "|"  and use the PATH functions.