Forum Discussion

misul's avatar
misul
Helper I
8 years ago

Nested IF formulas with OR statement

Hello PBI Community,  What would be a way to simplify this nested if statement?   Existing columns, X, Y related to other dimension tables.   Result= IF (related (X)=A1 || related (Y)= A1, A1, ...
Need Help
misul's avatar
misul
Helper I
8 years ago

Stachu OwenAuger Thanks for your tips. For my original problem your solution helps.

 

However, I have run into another issue which is that the last item from ValueList ("H1") is never returned,because of its position at the end of the list.

 

The new problem is that :

 

 

 

I am trying to create 1 new column [Result] based on a two columns [X] and [Y]. Both columns [X] and [Y] have the same 8 distinct values (A1... H1).

 

If I filter for A1, I want it to return all rows where both [X] is A1 and [Y] is A1.

 

OwenAuger's avatar
OwenAuger
Super User
8 years ago

misul

Sure - should be able to do that.

Just to clarify, do you want a way of filtering on the values A1..H1, then if, for example someone filters on A1, you return the union of rows where either [X] is A1 or [Y] is A1?

 

Could you post a quick example to confirm?

 

Thanks

Owen