Multiple Variant Type

[Rondel]

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 so I just replace it to contain a numeric value of 0, but wanted to see if its possible to keep the "N/A" text?

Sample Column:

$5,300,000

N/A

$1,000

N/A

etc.

[Anonymous · Accepted solution]

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.