Forum Discussion

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

General Comment

Interesting Links

Tutorial Requests

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

Community Support

8 years ago

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