Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I was trying to create a DAX expression and despite the data all being formatted correctly and no blanks etc. I was constantly getting this error message:
"The DAX expression for calculated table 'New Table' results in a variant data type for column 'Column A'. Please modify the calculation such that the column has a consistent data type."
Someone assisted me in resolving the issue but it had to be done as a work around because this bug kept causing issues when there was no problem with the data itself.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @LCTurner
After making changes to your DAX, there are no more corresponding errors. Since there is no further error information from your side, I will close the process of this thread. If you still have questions about this post, you can update it.
Best Regards,
Community Support Team _ Ailsa Tao