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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Gelain
Frequent Visitor

Column calculated with IF

Hi! 

 

Table A: szatendimento

datasaida

statusconta

30/05/2017

NULL

30/05/2017

C

 

I need to create a calculated column where:

 

If the datasaida column is filled and the account status is different from C, generate the letter F, otherwise generate the letter A.

 

I did so:

 

StatusF = IF (SZATENDIMENTO[DATASAIDA] <> BLANK (); "F"; "A")

 

I could not include the condition "and other than C".

 

I ask for help!

 

Thank you.

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@Gelain

 

StatusF = IF (SZATENDIMENTO[DATASAIDA] <> BLANK () && SZATENDIMENTO[STATUSCONTA]<>"C"; "F"; "A")




Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@Gelain

 

StatusF = IF (SZATENDIMENTO[DATASAIDA] <> BLANK () && SZATENDIMENTO[STATUSCONTA]<>"C"; "F"; "A")




Lima - Peru

Thank you @Vvelarde

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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