Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How do I convert a columns datatype in DAX?

Hoping this will be easy to answer.    I have a table which contains student results. Because of the different types of result that exist (9 to 1, and A to E), the data type has to be a string.   ...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    Can you try the following ? :

    Total Grades =
SUMX(
FILTER(YourTableName, ISNUMBER(VALUE(YourGradeColumn))),
IF(
ISERROR(VALUE(YourGradeColumn)),
0,
VALUE(YourGradeColumn)
)
)
Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
2 years ago

Hello Anonymous 

Use FORMAT DAX function to change the datatype of that particular column in your calculations. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!