Forum Discussion
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...
GilbertQ Below is the error i am getting. Now i am getting the data from 2 tables project, staff and calendar table is also used. Can you now suggest on this.
ErrorProjectSchema
Hi there
It is because the IF statement only accepts a single value to compare. You need to change the context to be using a measure value and not a column value.
It is because the IF statement only accepts a single value to compare. You need to change the context to be using a measure value and not a column value.
Can you please explain how can i implement the below logic now:
if(billingmethod= "FP" then use Measure1 else use Measure2)
- You could try it with a Variable such as below
My Measure =
VAR ValueToGet = SELECTEDVALUE(TableName[BillingMethod])
RETURN
IF(ValueToGet = "FP", [Total_Invoice].[Total_InvoiceTM])Thank you so much, it worked. I am new to learning power bi and dax. Can you please any book or online course where I can learn better and explore on myself.