Forum Discussion

varunv11's avatar
varunv11
Frequent Visitor
8 years ago
Solved

If Then - Need Help

Hello, 

 

I have a column on my model which give me the category of the product. And i have a calculated column for sales per product. I need to calculate the annualized sales per category.

 

In excel i use Annualised Sales = if(category = "ABC", Sales / 1.2, if(category = "XYZ", Sales / 3.5),0)

 

Category column is part of the model and is not a calculated value. Sales is a calculated measure created on BI. 

 

Please help. 

 

Warm Regards 

Varun Raj

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi varunv11,

     

    You could new a measure:

    Annualised Sales =
IF (
    SELECTEDVALUE ( Table[Category] ) = "ABC",
    [Sales] / 1.2,
    IF ( SELECTEDVALUE ( Table[Category] ) = "XYZ", [Sales] / 3.5, 0 )
)


    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi varunv11,

     

    You could new a measure:

    Annualised Sales =
IF (
    SELECTEDVALUE ( Table[Category] ) = "ABC",
    [Sales] / 1.2,
    IF ( SELECTEDVALUE ( Table[Category] ) = "XYZ", [Sales] / 3.5, 0 )
)


    Best regards,

    Yuliana Gu