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.
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
Solved! Go to Solution.
Hi @saipawar ,
If you want to create a custom column in Power Query, try this:
= 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:
= 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.
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
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.