Help with a conditional

[Syndicate_Admin]

Hello!

In my table I have three categories of product and quantities:

Category Quantity

Premium 50

Basic 30

Extra Costs 20

I need to create a new column "Quantity 2" To be able to multiply Quantity *2 only if it is Premium and if it is Basic or Extra Costs multiply it by 1.

[Samarth_18]

Hi @Syndicate_Admin ,

You can create a column as below:-

Quantity2 = if([category] = "Premium",[Quantity]*2,[Quantity]*1)

Thanks,

Samarth

[Syndicate_Admin]

I understand logic, but the category and Quantity columns are from my source table, they are not measured. so typing the dax function does not allow me to select the required columans

[Samarth_18]

@Syndicate_Admin , You could try this:-

Quantity2 = if('Table'[category] = "Premium",'Table'[Quantity]*2,'Table'[Quantity]*1)

[Syndicate_Admin]

it does not allow me to select the table, it only allows me to select measurements.

[Samarth_18]

@Syndicate_Admin Whats the error your getting. Could you please share the code which you trying?

[Syndicate_Admin]

My Table is called "SaleProducts", the column is "Product Category", when I try to write the function the table is not displayed:

[Samarth_18 · Accepted solution]

It seems you are trying to create a measure not column. In that case you can use this code:-

Quantity2 =
IF (
    SELECTEDVALUE ( 'SaleProducts'[Product Category] ) = "Premium",
    SELECTEDVALUE ( 'SaleProducts'[Quantity] ) * 2,
    SELECTEDVALUE ( 'SaleProducts'[Quantity] ) * 1
)