function to return a desired output

[Zaid_M93]

In the following photo we have a naming tool that is used in a warehouse. If we took the left side of the chart it is named as (A-B-3066), and the right side (A-CD6200-6799) and both are from (Level 2) data.

The desired function: search the string for how many (-) there are, then return the level of the given data and to distinguish that the right side is also a level 2 data type.

Thanks in advance.

[v-jiascu-msft]

@Zaid_M93

Hi,

Power BI can’t take pictures as data source. But if you had data like it in the picture below and wanted to calculate the level, this formula would help you.

The columns in red square just show the steps.

FinalFormula =

LEN ( Table1[Name] ) - LEN ( SUBSTITUTE ( Table1[Name], "-", "" ) )

Best Regards!

Dale