False return from table with Xlookup

[Anonymous]

When Xlookup is being used in an Excel table, the data is returned correctly in Excel but FALSE is returned in PowerBI online in all visuals.  This issue is not consistent and most of the time data is returned correctly.

Has anyone else noticed this and what is the solution?

[v-yetao1-msft]

Hi @Anonymous 

I don't quite understand what you mean, can you describe your problem in detail through screenshots or videos ?

Best Regards,
Community Support Team _ Ailsa Tao