Forum Discussion
how to create case statement with else
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.
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.