We're trying to build a formula using CASE WHEN syntax with multiple conditions using AND.
Example:
CASE WHEN MIN(MNDIFF([time A], [time B])) <= 30 AND [column A]='Value' THEN DUPCOUNT([column B]) ELSE 0
This syntax is not working. Any tips?
Hey bminehart ,
in case it's on a widget level, the Syntax seems to be OK, however, it's seems the Case when is apply on string, [column A]='Value', if that's the case, than it's not supported on the dashboard level. |
Please find an example Syntax
Best Regards
Thanks AssafHanina.
We're trying to apply the formula at the widget level and it is not working. I'll get a snippet of the complete function and error to share here.
Also: you say it's "not supported on the dashboard level" -- I don't understand how CASE WHEN logic can be used at the Dashboard layer? It's syntax used in a function, and aren't functions only a feature within widgets?
Hey bminehart ,
Sure please share the Snippet of the widget formula.
Meant that using CASE WHEN statements on string fields is not supported in widget formulas at the dashboard level, although it is supported within the data model.
Best regards
bminehart​ CASE statement on strings will work in the cube. We have pushed these calcs upstream to the cube or database level.
