Forum Discussion
Rondel
Helper I
Helper IMultiple Variant Type
Hi PBI Community, Is there a way to have a single column contain text and currency format like below? - The data source currently has "N/A" and dollar amounts. In power query it throws an error ...
Hi Rondel ,
This seems impossible; a column can only belong to one data format. If you want to keep "N/A", then the data type can only be text.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rondel ,
This seems impossible; a column can only belong to one data format. If you want to keep "N/A", then the data type can only be text.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.