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
iamblue91
Frequent Visitor

[Beginner Question] Calculated column?

I'm tyring to create a calculated column that will generate a yes / no. 

 

(Not actual data or names used)

 

The column "Permission Issued (code)" has options A, B, C, No, n/a. I want the new column (Permissed Issued (Y/N) to say "Yes" for A B, C, "No" for no, and not count or just carry over n/a for rows that have n/a.

 

I've already created a measure Permits Required = CALCULATE(COUNTROWS(Table1),Table1[Permit required (yes/no)]="Yes")

 

Happy to provide more details!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

A switch statement might also be worth considering:

 

= SWITCH(
	[Permission Issued (code)],
	"No","No",
	"n/a","n/a",
	"Yes"
)

View solution in original post

4 REPLIES 4
iamblue91
Frequent Visitor

Thanks every one! I guess I was just overthinking it!

paulag
Advocate I
Advocate I

create a calcualted column with an IF statement

 

=IF([Permission Issued (code)]="No","No", IF([Permission Issued (code)]="n/a","n/a","Yes")

Anonymous
Not applicable

A switch statement might also be worth considering:

 

= SWITCH(
	[Permission Issued (code)],
	"No","No",
	"n/a","n/a",
	"Yes"
)

Switch is probably easier than the IF statement

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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