Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditionally Negative Numbers Based on Another Table

Hi everyone!

 

I have a column with prices, and another column and another table with the acronyms C and D. That are Credit or Debit.

Tables are linked by a unique ID between them.

I need to turn prices to negative, when the acronym is D.

I am using SQL Server Analysis Services Tabular, how could I do this with DAX?

 

General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi ralsouza,

     

    Create a calculate column in table Toyota - Valores using DAX below:

    Conditional Prices =
IF (
    RELATED ( 'Toyota - Lancamentos'[tipolancto] ) = "D",
    - [Valor Toyota],
    [Valor Toyota]
)

    Regards,

    Jimmy Tao

     

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi ralsouza,

     

    Create a calculate column in table Toyota - Valores using DAX below:

    Conditional Prices =
IF (
    RELATED ( 'Toyota - Lancamentos'[tipolancto] ) = "D",
    - [Valor Toyota],
    [Valor Toyota]
)

    Regards,

    Jimmy Tao