Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When using two UNICHAR results for the return of a DAX IF function, the behavior is not expected.
As the following print screen:
The problem doesn't occur when using a UNICHAR result and a simple text
Here is the DAX formula
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous ,
May I know what’s the version of your Power BI Desktop? I tested with the latest version of Desktop(Version: 2.103.881.0 64-bit, March 2022). As you can see, it works well.
If you are not using the latest Desktop, please try with it. Here is the download link of the latest version: Download Microsoft Power BI Desktop from Official Microsoft Download Center. If you still have this problem in the latest one and don’t know the cause of it, could you please provide a download link of a sample pbix file that contains your issue so I can do further investigation on it?
In addition, please let me know how you configure your Regional Settings. Thanks in advance!
And I think you could try to replace the “(“ and “)” parts in your workaround formula with “” to remove ( and ) from the visual.
Best Regards,
Community Support Team _ Caiyun