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
Stachu's avatar
Stachu
Community Champion
8 years ago

can you share the sample data from tables containing X,Y, and the table where you add the calculated column?

my way of thinking would be - if you could determine A1-H1 with VAR then the syntax could be like this

Result = 
VAR varParameter = "A1:H1" //some proper syntax here
RETURN
IF(RELATED(X)=varParameter || RELATED(Y) = varParameter, varParameter, "None")