Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm using a lot of VAR a1 = something. Often this 'something' is a table or a calculation to get a table. My problem happens when I call a static table the same as the VAR. So the first scenario without an existing static table called a1.
How I see it happening, usually when referencing a table you use the apostrophe. For a VAR reference, you don't use it.
For what I've been told by our Microsoft representative is that the priority start with the static tables and then shift to the VAR reference. As there exist a a1 table in the second scenario, he assumes you want to use that one.
My solution would be simple. If a table reference contains an apostrophe in the beginning, it is referencing to a static table. Is there no apostrophe, it is referencing a VAR table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.