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
PA7177
Helper II
Helper II

Custom Column error

What am I doing wrong in this case?

 

TOKEN ERROR.PNG

1 ACCEPTED SOLUTION
PA7177
Helper II
Helper II

The issue is because one of the columns type was ABC123, after it was changed to text the formula worked. 

View solution in original post

4 REPLIES 4
PA7177
Helper II
Helper II

The issue is because one of the columns type was ABC123, after it was changed to text the formula worked. 

smpa01
Super User
Super User

if [x] = "yes" and if [y]="yes" then 1 else 0

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

It still doesn't work, even if I use 1 and 0TOKEN ERROR 2.PNG

Sorry my bad. gave you wrong solution initially. Apologies.

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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.