switch statement

Question

switch statement

Shambhu Rai 1,411

HI Expert,

unable to use switch statement in 2 table in ssas cube

i have used the switch statement but it is not taking columns from more than one table

I created calculated colmun via add new

2 answers

Your answer

Answer 1

Sedat SALMAN 14,180 MVP

After establishing a relationship between the tables, you can use the RELATED function to access the data from the related table.

SWITCH (
    [Column1], 
    "Value1", RELATED(Table2[Column2]),
    "Value2", RELATED(Table2[Column3]),
    "Other"
)

RELATED function works by following the relationships that you have defined in your data model. If there isn't a direct relationship between the tables, you may need to create one or modify your data model to support the calculations you're trying to perform.

https://learn.microsoft.com/en-us/dax/related-function-dax

Shambhu Rai 1,411 Reputation points

2023-06-18T15:07:18.76+00:00

it is joined between main fact table example then how to join

actually table1- dept ,empid

table2 deptid,deptname

table3 emp id,empname

switch statement used in

table1--->table3

table1--->table2

so using switch(table2,deptname=Central, table3.empaname)

empname is value not coming
Erland Sommarskog 122K Reputation points MVP Volunteer Moderator

2023-06-18T17:36:45.7333333+00:00

Since I don't use SSAS, I have nothing to add in the thread as such, but I like to inform you of the house rules. You posted this both as a Comment and an Answer. As a moderator, I have deleted the Answer. Answers for, yes, answers to the original question. As the person asking the question, you would only post an Answer if you find the solution yourself. Else you should stick to comments.
Shambhu Rai 1,411 Reputation points

2023-06-19T00:16:12.9633333+00:00

Suggestion Please
Shambhu Rai 1,411 Reputation points

2023-06-19T08:09:32.1+00:00

suggestion please
Shambhu Rai 1,411 Reputation points

2023-06-19T10:40:28.8466667+00:00

suggestion please
Shambhu Rai 1,411 Reputation points

2023-06-19T19:48:58.6333333+00:00

suggestion pls
Erland Sommarskog 122K Reputation points MVP Volunteer Moderator

2023-06-19T21:11:03.7333333+00:00

My suggestion is that you behave properly. Posting Suggestion please every four hours is not how you behave in a forum. Maybe the reason you don't get an answer is that no one here knows SSAS well enough to answer. Or maybe the question is too vague, and you need to clarify with more code. Not sure how you post CREATE TABLE + INSERT with SSAS (I don't SSAS at all myself), but something which makes it clear what you are looking for.

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

switch statement

2 answers

Your answer