topic Re: Hands up if you ... in DAX Commands and Tips

Hands up if you ...

garythomannCoGC — Thu, 20 Apr 2023 06:12:53 GMT

Building a simple table of reference constants in pbi desktop.

Query works in daxstudio but falls over in pbi desktop.

daxstudio

pbi desktop

ERD — Thu, 20 Apr 2023 07:28:29 GMT

Remove 'EVALUATE' from your table definition in pbi desktop.

garythomannCoGC — Thu, 20 Apr 2023 22:15:20 GMT

Good. Now why? :}

ERD — Fri, 21 Apr 2023 06:17:20 GMT

EVALUATE is a keyword automatically included by Power BI in every query. It’s used to answer and create your visuals in Power BI.