Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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-EuA6iNQi3fYoLuIqYBeWawIwHhoNTm
Solved! Go to Solution.
Hello @mohittimpus ,
You can create calculated column by going to Modelling>New Column.
Please let me know if this didn't help.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |