Forum Discussion
evalromf
Helper I
Helper IAND 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
Super User
Super UserYou could try it with a Variable such as below
My Measure =
VAR ValueToGet = SELECTEDVALUE(TableName[BillingMethod])
RETURN
IF(ValueToGet = "FP", [Total_Invoice].[Total_InvoiceTM])
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.