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...
Hi GilbertQ
Its difficult to post data as it is coming from two or three tables and they contain many columns. But can you explain why i am not able to put a simple condition.
Example if am i am doing (billing = "FP") it should not give at row level but at the aggregated level without being affected by other columns in the report.
How can i create a measure so that it gives billing = FP without getting affected by any dimension??
Hi there
I would suggest first to simplify your model design if you are trying to achieve this from 2-3 different tables. Ideally all that information would be contained in 1 table.
The challenge is that when creating a measure it does not work on a column basis but rather works on returning a single scalar value. With the IF condition it still expects to get a single value once evaluated?
I would suggest first to simplify your model design if you are trying to achieve this from 2-3 different tables. Ideally all that information would be contained in 1 table.
The challenge is that when creating a measure it does not work on a column basis but rather works on returning a single scalar value. With the IF condition it still expects to get a single value once evaluated?
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.
Can you please explain how can i implement the below logic now:
if(billingmethod= "FP" then use Measure1 else use Measure2)