The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |