Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |