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

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 :

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I appreciate all your help on this!