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
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