Forum Discussion
Solved
Model Relationship
Hi All, Basically I am unable to create relation between two tables.There is one table with Static data :Type,key service level(consider as formula names). Another table with raw data but both th...
SWITCH is a function used in measures /calculated columns wich is essentially nested IFs executed in order. So the measure in this case is checking the filter context (established by SELECTEDVALUE) and returning the corresponding measure. So the first statement checks whether the conext is "A1" and if true returns the measure [M1] and so on...Make sense?
Can you explain brief please ? I am a begginer.
Do you mean to create a new column using the above switch statement ? if so in which table ? The one having static data or the one where we have calculated the measures.
You need to create a new measure with the code. Then create a new table visual, add the fields from Table 1 and add the measure