Forum Discussion
undefined
rubayatyasmin i need output as text without the bracket ex : Head Office I used to write the code Right ( dim( customer) , search("(" , dim( customer) 1, len ( dim( customer )+1)-1) ...
Still N/A not displayed
Try
Bill to Customer 2 =
VAR String = dimCustomer[Bill to Customer]
VAR Items = SUBSTITUTE ( SUBSTITUTE ( String, "(", "|" ), ")", "|" )
VAR Result = PATHITEM ( Items, 2 )
RETURN
IF ( Result = BLANK ( ), "N/A", Result )This is not my code.
ok I will try your code . Above image see my code and my output. in output head office showing but in N/A only showing A alone wht is the issue in my code plz tell .
@I have one doubt in Power bi service. In dashboard tile refresh failed.wht are the steps u follow ( one intervention questio
Karthikgayathri check refresh failure message. Then troubleshoot it.
