powerquery - Dual data type of specific column as per different selection?

Question

I have 2 column "Order Quantity"(data type whole no) and "Product"(data type text). Now what I want, when I select ProductA the datatype of "Order Quantity" column should be decimal otherwise in whole number. I Tried a lot but I failed to resolve my issue. Plz anyone help me regarding this,

Input:

Output:

Objective: For ProductA "Order Quantity" data type should be in decimal and rest of the Product(B,C and D) data type should be display in Whole number

Is it possible can we display mixed data type in specific column as per selection of Product? E.g. I applied this query but it doesn't work

• newvar=Table.TransformColumnTypes(#"Changed Type",[Order Quantity], each [Product]<>"A", Number.Type([Order Quantity]))

Output screen:

question from:https://stackoverflow.com/questions/65840673/dual-data-type-of-specific-column-as-per-different-selection

Answer 1

Waitting for answers