RETURN in the middle of a DAX statement

Hila_DG_TMX — Fri, 01 Nov 2024 01:27:07 GMT

Hi,

I have a complex DAX statment to calculate a column (yes, I know, don't get me started).

It works.

It has several calculations, all organised nicely using VAR statements.

The issue is as follows:

I want the code to return a specific value if a certain condition is met in the 1st go, and then not run through the extra caculations.

So, instead of:

0.1 My Col = _VAR _V1 = calc _VAR _V2 = calc _VAR _V3 = calc VAR _RET = IF (Table[column], 8, _v1 + v2 +v3) RETURN _RET

Which means I would run all 3 calcs,

I want to write something like:

0.1 My Col = IF (Table[column], RETURN 8, _VAR _V1 = calc _VAR _V2 = calc _VAR _V3 = calc RETURN _v1 + v2 +v3 )

I don't get it to work.

Is it even possible? Thanks!

Re: RETURN in the middle of a DAX statement

OwenAuger — Fri, 01 Nov 2024 01:39:01 GMT

This should be the correct syntax:

0.1 My Col = IF ( Table[column], 8, VAR _V1 = calc VAR _V2 = calc VAR _V3 = calc RETURN _V1 + _V2 + _V3 )

The three variables should only be evaluated when the condition within IF is false.

Does this work as expected for you?