Forum Discussion

evalromf's avatar
evalromf
Helper I
9 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.

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

Should it not be the following:

M 3 = IF(VALUES(TableName[Billing]) = "FP",[M1],[M2])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
     
     
     
     

    Before I was getting proper OutputNew measure is not working fine

     

    Hi GilbertQ 

     

    I tried this but when i am using it in report its not working fine as the report contains the columns from other tables  like T1, T2