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 ...
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

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