Measure Dynamic formatting error when export to Excel from Power BI Service

[Lionel_G]

Hello,

I get an error when trying to export a visual table in Excel : 

I realized that when displaying a measure with a dynamic format, the error is raised.

When I remove it, no error.

Here is the dynamic format formula :

VAR currSymbol = FIRSTNONBLANK(F_Compensations[First locale currency this year], 1)
RETURN
"# ### ### ##0" // Format numérique
& " "
& currSymbol // Symbole de la devise

Thank you for your help

Lionel

[Lionel_G]

Interesting, I just solved the problem by putting double quotes before and after the string in the format and this worked in Excel without error : 

VAR currSymbol = """" & FIRSTNONBLANK(F_Compensations[First locale currency this year], 1) & """"
RETURN
    "### ### ### ##0" & " " & currSymbol

[v-xiaoyan-msft]

Hi @Lionel_G ,

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

Best regards.
Community Support Team_ Caitlyn