Forum Discussion

mohittimpus's avatar
mohittimpus
Helper V
6 years ago
Solved

How to create Calculate column in Direct Query Mode

I need to create Calculate Column in Direct Query Mode. How to create Calculate Column in Direct Query Mode?  I am sharing a Demo File in Below link:   https://drive.google.com/open?id=10-EuA6iNQi...
Need Help
rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Hello mohittimpus ,

 

You can create calculated column by going to Modelling>New Column.

Please let me know if this didn't help.

  • mohittimpus's avatar
    mohittimpus
    Helper V
    6 years ago

    I can make the calculate column but when I try to make the calculate colaumn like this it not not give me correctr result.

     


    No Injury / Injury = IF ('''SHC Fall Data$'''[Outcomes] = "Fall1-None"
    || '''SHC Fall Data$'''[Outcomes] = "Fall1-None Fall1-None"
    || '''SHC Fall Data$'''[Outcomes] = "Fall1-None No Injor",
    "No Injury", IF('''SHC Fall Data$'''[Outcomes] = "Fall2-Mild/Minor" || '''SHC Fall Data$'''[Outcomes] = "Fall2-Mild/Minor Fall2-Mild/Minor"
    || '''SHC Fall Data$'''[Outcomes] = "Fall2-Mild/Minor Fall2-Mild/Minor Fall2-Mild/Minor"
    || '''SHC Fall Data$'''[Outcomes] = "Fall2-Mild/Minor *** Fall2-Mild/Minor"
    || '''SHC Fall Data$'''[Outcomes] = "Fall3-Moderate"
    || '''SHC Fall Data$'''[Outcomes] = "Fall4-Major"
    || '''SHC Fall Data$'''[Outcomes] = "Fall5-Death","Injury"
    ))

     

    In above Dax that hard code value is not reconsigned in Direct query and new column is not give result "injuery" or "Non injuery".

     

    Same code is working prefectly in import format.