Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Switch True

DAX experts,  Here is how my data is set up: ID:       Reason 1       Reason 2      Reason 3       Reason 4 1                    Correct          Incorrect      Incorrect       Correct 2         ...
  • Rahal's avatar
    Rahal
    6 years ago

    So, with the structure of your data you can only get something like this :

    Otherwise you need to transform your data, for that u need to use SQL,

    here i'm ganna start by creating my table Check :

    Then i can tranform it also with Sql :

     

    So finaly i can get what i need on Power BI :

     

Rahal's avatar
Rahal
Frequent Visitor
6 years ago

Hi,

 

thats a mesure, and yeah the ; on your case is a comma ,

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Rahal 

    That is working now thank you for all your help! 

     

    The only thing I am struggling with now is the Return statement

     

    How do I get the return statement to use the reason as a column header and the R1 value as the value for that reason.