convert the str function to a DAX String Function

[efekrags]

Need Urgent Help .Please How do I replicate this tableau Formula to a DAX Formula

If [Business Unit] = "TMG"
Then
STR(int(Mid([Product Code], Find([Product Code],"-",
FIND([Product Code], "-", 1) + 1) + 1,
(FIND([Product Code], "-",
FIND([Product Code], "-", FIND([Product Code], "-", 1) + 1) + 1))
-
(FIND([Product Code],"-",
FIND([Product Code], "-", 1) + 1) + 1))) * 1)
ELSE
[Product Code]
END.

what String function can I use in place of STR in this code?

[v-easonf-msft · Accepted solution]

Hi, @efekrags 

STR( ) is a data type conversion function in Tableau, which can convert numeric variables or constants into character variables or constants.

In powerbi, it's unnecessary to use function to convert data types.You can directly change the Data type of calculated columns in the Column Tool as below:

If you don’t like this method of manually changing the data type, you may try the format function.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lauriemclolo]

why is this listed as a solution?

[amitchandak]

@efekrags , what are you trying to achieve here

Something like this

MID([Product Code], search("-",[Product Code],,0)+1, len([Product Code]))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer :

to Split column in power query

https://www.youtube.com/watch?v=FyO9Vmhcfag

Power Query - Text.Start, Text.Middle, Text.End

https://www.youtube.com/watch?v=vky4wPqm0O0

DAX - MId, right, left : https://www.youtube.com/watch?v=-KChpAz_fUo

Search and find : https://www.youtube.com/watch?v=mZt0HJw4gjQ