Forum Discussion

bboy0009's avatar
bboy0009
Icon for Helper II rankHelper II
3 years ago
Solved

Optimization by choosing good data type

Hi guys, I am analyzing a PIBX and the previous developer has created a lot of steps to change the alphanumeric type to text. I think it's not mandatory to the restitution so I would like to delete ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, bboy0009 

    According to your description, your column is alphanumeral, if your column contains strings and numbers, I recommend that you use the Text format, because the data in this case exists strings, and we should use Text to identify it. In Power BI, this type should also be treated as text.

    Whether it will have an impact if you want to convert the format needs to be judged comprehensively based on your business logic and existing operations.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

Impossible to say without seeing the details.

Maybe think about what problem you are trying to solve.  Do you have a performance or size problem?  Or is there complicated dax that you can simplify by using a numeric type rather than text?