How to use multiple if staements in a collum

[Anonymous]

Hi,

I'm new to PowerBI and making reports for my company.

In PowerBi i'd made a new collum to do a calculation for an end reason of a product where the value is 50% of the original .

Those reason have a code.

When i do this on one stement it works great, however if i want to ad more values it doesnt work any more.

This is what i made:

mBedragBeschikt werkelijk = IF(FeitNVTZ[rRedenEinde}= 9; [mBedragBeschikt}/2;[mBedragBeschikt])

This do the job, only now i want to add a value 10 and 12 as well .

Can anyone help me on this?

[AlB · Accepted solution]

hi @Anonymous

You mean you want to tdo the same operation when the value is 9, 10, or 12? If so,

mBedragBeschikt werkelijk =
IF (
    FeitNVTZ[rRedenEinde] IN { 9; 10; 12 };
    [mBedragBeschikt] / 2;
    [mBedragBeschikt]
)

Otherwise please explain with an example what exactly you are looking for

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[Anonymous]

---

@AlB wrote:

hi @Anonymous

You mean you want to tdo the same operation when the value is 9, 10, or 12? If so,

mBedragBeschikt werkelijk =
IF (
    FeitNVTZ[rRedenEinde] IN { 9; 10; 12 };
    [mBedragBeschikt] / 2;
    [mBedragBeschikt]
)

Otherwise please explain with an example what exactly you are looking for

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

---

Yes this is exactly what i needed.

Thank you