Forum Discussion
how to create case statement with else
How to create a case statement with "else" of SQL?
I would like to create a new measure or column with two groups -
a) Launch Content
b) Not launch content
Here's how my data looks -
| Launch Content |
| JAN - hybrid installs |
| FEB - KPIS |
| FEB - SD WAN |
| Not launch related |
| Not launch related |
| APR - Mimics |
| JUL - Hiking |
| OCT - qwerty |
Not launch related
|
Output -
Rows with "Not a launch content" to be grouped as "Not considered" and rest as "Considered Content"
Here's my current code for new column -
Is Launch Content =
IF(CONTAINSSTRING([Launch Content],"Not launch related"),"Not considered",
ELSE,"Considered Content"
)
Thanks
Hi saipawar ,
If you want to create a custom column in Power Query, try this:
- Create a conditional column.
- Or, create a custom column.
= if Text.Contains([Launch Content],"Not launch related") then "Not considered" else "Considered Content")If you want to create a calculated column in data view, try this:
Is Launch Content = IF ( CONTAINSSTRING ( [Launch Content], "Not launch related" ), "Not considered", "Considered Content" )Is Launch Content 2 = IF ( FIND ( "Not launch related", [Launch Content],, 0 ) <> 0, "Not considered", "Considered Content" )Is Launch Content 3 = IF ( SEARCH( "Not launch related", [Launch Content],, 0 ) <> 0, "Not considered", "Considered Content" )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
hi, try this:
Is Launch Content =
IF [Launch Content]="Not launch related"THEN "Not considered"
ELSE "Considered Content"
// if this is a solution please mark as such. Kudos always appreciated.
This gives an error saying "Unexpected expression THEN" and "Syntax for THEN is incorrect"
Is there any other alternative to this?
Sorry. case sensitive
Is Launch Content =
IF [Launch Content]="Not launch related"then "Not considered"
else "Considered Content"
// if this is a solution please mark as such. Kudos always appreciated
Hi saipawar ,
If you want to create a custom column in Power Query, try this:
- Create a conditional column.
- Or, create a custom column.
= if Text.Contains([Launch Content],"Not launch related") then "Not considered" else "Considered Content")If you want to create a calculated column in data view, try this:
Is Launch Content = IF ( CONTAINSSTRING ( [Launch Content], "Not launch related" ), "Not considered", "Considered Content" )Is Launch Content 2 = IF ( FIND ( "Not launch related", [Launch Content],, 0 ) <> 0, "Not considered", "Considered Content" )Is Launch Content 3 = IF ( SEARCH( "Not launch related", [Launch Content],, 0 ) <> 0, "Not considered", "Considered Content" )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Icey Thanks a lot for laying out all the options. Your is one of the best solutions I've come across in the community to date.
I went with the conditional column approach and it worked. Thanks.Ultimately, after grouping 'Considered" and "Not considered" values, I would like to put them in a table against the months.
Here's my desired output -
Month Considered Not considered January 12 4 February 2 7 March 23 1 How can I achieve this?
Currently, when I pull the new column in values, I can use it only once to filter the data either for "Considered" or "Not considered".
Do I need to create 2 different conditional columns then? or please recommend the best approach.
Thanks again
Hi saipawar ,
Please consider to create a Matrix visual. Then, put "Month" column into "Rows" field, "Is Launch Content" column into "Columns" field and Count of "Is Launch Content" column into "Values" field.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
