Forum Discussion
IFS (Dutch als.voorwaarden) Formula Excel
Hi,
I've been searching in this forum, but couldn't find the right answer.
I'm trying to use the IFS formula out of Excel (2016) in PowerBI desktop.
The formula is as below:
=IFS([@[KP-Project]]=4755;"Project eigen KP";[@[KP-Project]]>0=OF([@[KP-Project]]<4755);"Project andere KP's";[@[KP-Project]]>4755;"Project andere KP's";[@Project]>299=OF([@Project]<400);"Indirecte uren";[@Uurcode]>0=OF([@Uurcode]<80);"Overig (improductief)";[@Uurcode]=180;"Overig (improductief)";[@Activiteit]=200;"Project andere KP's";[@Uurcode]=0;"Project andere KP's")
The reason i'm using this formula is; I need to get data out of several columns (not all the data in 1 column) to get one column with the right data for a diagram.
I hope anyone could help me out. If this formula is not possible, maybe someone knows how it would work aswell?
Hi RemcoJansen,
In your scenario, did you want to return the result in a column or return them into multiple column?If you want to return them in a column, you need to combine the logic. If you want to return them into multiple column, you could create multiple custom columns, then use expression like below in column
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
daxCommunity Support
Hi RemcoJansen,
In your scenario, did you want to return the result in a column or return them into multiple column?If you want to return them in a column, you need to combine the logic. If you want to return them into multiple column, you could create multiple custom columns, then use expression like below in column
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.