Forum Discussion

evalromf's avatar
evalromf
Icon for Helper I rankHelper I
10 years ago

AND IF in conditional column

Hi,   I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns.   What I'm looking for is something like this:   If [COUNT...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi all,

 

 

I have 2 measures (M1, M2) which are working fine in two separate scenarios. But now i need to combine these two scenarios.


I have to put a simple condition in a final measure (M3) using column "Billing"

 

M3 = If ( Billing = "FP", M1,M2)

 

But I am unable to use column name in the measure. Please help.