cancel
Showing results for
Did you mean:
Highlighted
Helper III

## Looking for a formula Newbie question

Hallo everybody,

Im looking for a formula when the Column Facturatie compleet says Nee. it will make the cell blank in column afwijking t.ov. raming(%).

1 ACCEPTED SOLUTION

Accepted Solutions
Solution Sage

## Re: Looking for a formula Newbie question

I assume you've got a measure that's working out the current output where it's not Nee right now, so you want something like:

newmeasure = if([facturatiecolumn]="Nee",blank(),[existingmeasure])

4 REPLIES 4
Solution Sage

## Re: Looking for a formula Newbie question

I assume you've got a measure that's working out the current output where it's not Nee right now, so you want something like:

newmeasure = if([facturatiecolumn]="Nee",blank(),[existingmeasure])

Helper III

## Re: Looking for a formula Newbie question

sorry for not being precise.

the output should be if Ja then do nothing. (show the value in afwijking...)

Resolver III

## Re: Looking for a formula Newbie question

You should create new measure (or new calculated column) with condition, like above ( @jthomson).

Best regards

Helper III

## Re: Looking for a formula Newbie question

Afwijking t.o.v. raming = if([Facturatie compleet]="Nee";blank();[Afwijking t.o.v. raming (%)])

Thank you all.

Greetings from the Netherlands,

Charaf

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors