Forum Discussion

llm's avatar
llm
Frequent Visitor
4 years ago
Solved

SQL Case Statement to Dax

Hi In the instructions it says not to ask about SQL conversions but I'm willing to take a chance that someone can help . I am a beginner with Power Bi & Dax and having difficulty converting the follo...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    I would look at using SWITCH but in the form

     

    SWITCH (

       True,

       Case1, Outcome1,

        Case2, Outcome2

       ....

    )

     

    See the example in https://dax.guide/switch/

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi llm ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.If not solved ,could you pls share your sample data in SQL,and expected output.

Remember to remove confidential data.

 

 

Best Regards
Lucien