cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nidhi_Kochrekar
Frequent Visitor

IF Else ?

Hello,

 

I am trying to add new column

 

if Text.Contains([SVTTitle]="Response") and ([MeasurementStatus]=5) then "Response Missed"

else if Text.Contains ([SVTTitle]="Resolution") and ([MeasurementStatus]=5) then "Resolution Missed" else "Total Tickets"

 

where SVTTitle is Text and MeasurementStatus is whole number

 

There is no error in syntax but getting error in column

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @Nidhi_Kochrekar 

The error should be caused by wrong format in Text.Contains fuction. It should looks like Text.Contains("Hello World", "Hello").

Please try this code.

if Text.Contains([SVTTitle],"Response") and ([MeasurementStatus]=5) then "Response Missed"

else if Text.Contains ([SVTTitle],"Resolution") and ([MeasurementStatus]=5) then "Resolution Missed" else "Total Tickets"

Result is as below.

1.png

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
RicoZhou
Community Support
Community Support

Hi @Nidhi_Kochrekar 

The error should be caused by wrong format in Text.Contains fuction. It should looks like Text.Contains("Hello World", "Hello").

Please try this code.

if Text.Contains([SVTTitle],"Response") and ([MeasurementStatus]=5) then "Response Missed"

else if Text.Contains ([SVTTitle],"Resolution") and ([MeasurementStatus]=5) then "Resolution Missed" else "Total Tickets"

Result is as below.

1.png

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Tahreem24
Super User
Super User

@Nidhi_Kochrekar , Create a Calculated column using below DAX:

New Column = IF( SEARCH ("Response",SVTTitle,1,0)>1 && MeasurementStatus=5, "Response Missed",
                              IF(SEARCH ("Resolution",SVTTitle,1,0)>1 && MeasurementStatus=5, "Resolution Missed", Total Tickets)

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors