Switch statement conversion issue

[Anonymous]

Hi,

I'm trying to debug the below switch statement but facing issues with the conversion.

Once this is debugged, I want to extend the switch statement.

[v-stephen-msft]

Hi @Anonymous ,

The SWITCH evaluates an expression against a list of values and returns one of multiple possible result expressions.

And the syntax of SWITCH is

SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])  

The expression's definition is that any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context).

However, the DATESBETWEEN returns a table that contains a column of dates that begins with a specified start date and continues until a specified end date. 

This function is suited to pass as a filter to the CALCULATE function. Use it to filter an expression by a custom date range.

Reference: https://docs.microsoft.com/en-us/dax/datesbetween-function-dax

                  https://docs.microsoft.com/en-us/dax/switch-function-dax

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous DATESBETWEEN is going to return a table of dates but using SWITCH(TRUE()...) you need the left hand of each pair of expressions to evaluate to a TRUE/FALSE statement/logic.