topic Re: DAX interpreter BUG!!! in DAX Commands and Tips

DAX interpreter BUG!!!

Element115 — Sat, 06 Aug 2022 01:36:52 GMT

The following (code in red) works when run in the Power Bi Desktop version, but as soon as you replace it by the variable name, which contains the same code, Power BI generates an error. In a nutshell, the column [UnreachableSince] is of data type TEXT containing textual representations of DATETIME values and other non-datetime values (I know and there is nothing I can do about this).

To intercept the DATETIME values, therefore an IF() is used. It all works fine until you decide to use the variable name in place of the inline code inside the nested IF().

So this OK:

DATEDIFF(DATEVALUE([UnreachableSince]) + TIMEVALUE([UnreachableSince]), [ClosedDT], SECOND)

But this NOT OK!

DATEDIFF(__unreachable_dt, [ClosedDT], SECOND),

Code here (sorry but can't add colors when using Insert/Edit code sample from this editor toolbar):

ADDCOLUMNS(
GROUPBY(
ADDCOLUMNS(
CALCULATETABLE(
SELECTCOLUMNS(
...
),
FILTER(
...
)
),
"DownTime", IF ( [ErrorCategory] == "Unreachable",
VAR __unreachable_dt = DATEVALUE([UnreachableSince]) + TIMEVALUE([UnreachableSince])
VAR __unreachable_dt_in_secs = DATEDIFF(__start_date, __unreachable_dt, SECOND)
RETURN
IF( __unreachable_dt_in_secs >= 0,
DATEDIFF(DATEVALUE([UnreachableSince]) + TIMEVALUE([UnreachableSince]), [ClosedDT], SECOND),
BLANK() //DATEDIFF([CreationDT], [ClosedDT], SECOND)
),
DATEDIFF([CreationDT], [ClosedDT], SECOND)
)
),
[AssetName],
"DownTime", SUMX(CURRENTGROUP(), [DownTime])
),
"% up", 1 - ([DownTime] / __in_service_time)
)

So am I imagining things, or isn't this a DAX interpreter bug?

Re: DAX interpreter BUG!!!

Element115 — Sat, 06 Aug 2022 02:22:23 GMT

PBI Desktop vs = July 2022

Re: DAX interpreter BUG!!!

v-easonf-msft — Tue, 09 Aug 2022 02:26:44 GMT

Hi, Element115

Although variables can be used anywhere, however, their result might not be always the same. Because they are evaluated in the context in which they are written.

Please refer to this thread for more details.

Caution When Using Variables in DAX and Power BI

Best Regards,
Community Support Team _ Eason

Re: DAX interpreter BUG!!!

Element115 — Mon, 22 Aug 2022 19:17:59 GMT

TBH what you are saying makes no sense to me: variables

are evaluated in the context in which they are written.

Variables should be visible in the scope in which they are declared, period. Are you saying that DAX scoping isn't following what we are used to with all major programming languages out there?

In any case, all my variables are usually declared top level, ie right after the 'MeasureName = ' line. Therefore I would expect this scope to be visible all the way down to the RETURN statement.

Isn't it so?

Re: DAX interpreter BUG!!!

Element115 — Tue, 06 Sep 2022 20:29:07 GMT

One more thing... I read RADACAD's explanation, however it does not apply here. Look again carefully at the code I posted:

"DownTime", IF ( [ErrorCategory] == "Unreachable", VAR __unreachable_dt = DATEVALUE([UnreachableSince]) + TIMEVALUE([UnreachableSince]) VAR __unreachable_dt_in_secs = DATEDIFF(__start_date, __unreachable_dt, SECOND) RETURN IF( __unreachable_dt_in_secs >= 0, DATEDIFF(DATEVALUE([UnreachableSince]) + TIMEVALUE([UnreachableSince]), [ClosedDT], SECOND), BLANK() //DATEDIFF([CreationDT], [ClosedDT], SECOND) ),

__unreachable_dt is declared right before the RETURN statement and when referenced in the RETURN block inside de DATEDIFF() inside the IF() as the 2nd parameter, the result is not that the computation is wrong.

In other words, the block of code is

IF( condition, VAR __declaration0 = ... VAR __declaration1 = ... RETURN IF( __declaration1 >= 0, // no issues here referencing the second variable DATEDIFF( __declaration0, ... ) // issue here CAN'T FIND THE VARIABLE!!! ... Is this really as it should be???

The result is that the interpreter complains the variable does not exist or is not defined! Two very different things, yes?

Re: DAX interpreter BUG!!!

Element115 — Tue, 06 Sep 2022 18:17:40 GMT

Hello, any updates?