Conditionally Negative Numbers Based on Another Table

[Anonymous]

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?

[v-yuta-msft · Accepted solution]

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