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