Forum Discussion

walker4545's avatar
walker4545
Frequent Visitor
4 years ago
Solved

Cannot convert value of type Text to type Integer.

Hi PowerBI community,  I'm attempting to use a Switch Statement in DAX to create customised column of categories using 'Proposed Start Date' dates (in date format) for travel bookings:   Proposed...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi walker4545 ,

     

    It looks like this is because the column previously returned values of Whole number type, causing an error when the output is text. Please select the calculated column and change the format to text.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

Hi walker4545 ,

 

It looks like this is because the column previously returned values of Whole number type, causing an error when the output is text. Please select the calculated column and change the format to text.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.