Forum Discussion
Multiple If Statement with 2 tables
Hi, Below is a half attempt of what I am trying to accomplish, I am looking to see if anyone can help. I have 2 tables and they are related like this based on the column: InterimWorkin...
If you want to use IF statement in a measure, you have to use a measure as its parameter. For your case, you can create a measure and call VALUES to get the value from InterimWorkingProject.Return. Then use it in your IF statement.
ok, I am following you, so i just made a new measure: returnvalue = Values(INTERIMWORKINGPROJECT[Return])
and then I went to create a new measure like this:
Charge = if([returnvalue] = "1120S", 120, 0) but i get an error when i add it to my table
error: