I keep getting Syntax errors, can someone help me please?

Question

Here's my measure:&nbsp;Provider ID =IF(&nbsp; &nbsp; ISBLANK(&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; LOOKUPVALUE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Provider Lookup'[Provider ID], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Provider Lookup'[Provider Name], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Code Stroke DDR'[Who provided Telestroke Service]&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ),&nbsp; &nbsp; "No ID", &nbsp;-- Default text value for blank entries&nbsp; &nbsp; FORMAT(&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; LOOKUPVALUE(&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Provider Lookup'[Provider ID], &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Provider Lookup'[Provider Name], &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Code Stroke DDR'[Who provided Telestroke Service]&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; ),&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; "General Number" &nbsp;-- Converts numeric values to text&nbsp; &nbsp; ))Here's the Syntax Error:&nbsp;The following syntax error occurred during parsing: Invalid token, Line 4, Offset 5, &nbsp;.

rohit1991 · Accepted Answer

Hi&nbsp;wbarnes&nbsp;,
In DAX, string outputs in a measure must be returned as a DAX expression, not as comments (i.e., you can’t use -- for comments inside the formula).&nbsp;Also, "General Number" is not a valid format string for FORMAT—use "#" or just wrap the number in FORMAT without a format string.
Provider ID =
VAR ProviderID = 
    LOOKUPVALUE(
        'Provider Lookup'[Provider ID],
        'Provider Lookup'[Provider Name],
        'Code Stroke DDR'[Who provided Telestroke Service]
    )
RETURN
IF(
    ISBLANK(ProviderID),
    "No ID",
    FORMAT(ProviderID, "")
)

Forum Discussion

I keep getting Syntax errors, can someone help me please?

2 Replies

Related content

Getting Error Cannot load model

getting error

Getting FUll memory Error

Get Activity Events API - PowerBINotAuthorizedException Error

Get Error in Service