Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jimpatel
Helper V
Helper V

If statement

Hi

Thanks for looking at my post.

 

I am using if statement like below, what i got stuck is, i wanted to use last if statement for anything starting with "Task*" followed by anything. But for some reason this is not working. Any idea please? 

Plus any idea of how to make case insensitive please. That is either caps or small letters i wanted to pull those data please.

 

Thanks a lot

 

IF('Work'[Column3]="Table","Working",IF('Work'[Column3]="Resign","Working",IF('Work'[Column3]="Task*","Working","Not-Working")

 

 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @jimpatel ,

 

You want to use LEFT() i.e. IF( LEFT( Work[Column3], 4 ) = "Task"...

Dax IS case insensitive.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

5 REPLIES 5
jimpatel
Helper V
Helper V

Perfect 🙂

 

Thanks a lot 🙂

jimpatel
Helper V
Helper V

Perfect

 

Thanks a lot 

BA_Pete
Super User
Super User

Hi @jimpatel ,

 

You want to use LEFT() i.e. IF( LEFT( Work[Column3], 4 ) = "Task"...

Dax IS case insensitive.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




What if i need to do below condition please.

 

That is anything starting with any string but have "Task" anywhere in the sentences please?

 

Thanks a lot and sorry for more question

 

No problem. You would use CONTAINSSTRING(), something like this:

IF( CONTAINSSTRING( Work[Column3], "Task" ) ...

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors