We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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 not work in Power BI Desktop.
Column1 = test1_test2_test3
Formula: Last_Replaced = Last_Replaced = SUBSTITUTE(table1[Column1],"_","@",LEN(table1[Column1])-LEN(SUBSTITUTE(table1[Column1],"_","")))
This returns "An argument of function 'SUBSTITUTE has the wrong data type or has an invalid value."
However, if I set the number to 2 in the forumla it works.
If I first create a column that determines the value and holds this then include that new column in the formula it fails with the same error.
Is this by design, a bug, or is there another way to accomplish what I'm trying to do in Power BI Desktop?
Thank you,
Trav
Solved! Go to Solution.
Replace your underscore "_" with a pipe "|" and use the PATH functions.
Replace your underscore "_" with a pipe "|" and use the PATH functions.
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
20 | |
14 | |
11 | |
5 |