Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

pb version

Hello everyone, I got one more problem   I got one data table like this : No      Archived       Amount        Amount Arch     Measure Ord1   NO                10€               0€              ...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi bapt69,

     

    To achieve your requirememt, you can create a calculate column instead using DAX below:

    Column = IF(Table1[Amount] = 0, Table1[Amount Arch], Table1[Amount])

     

     

    Regards,

    Jimmy Tao

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

Hi bapt69,

 

To achieve your requirememt, you can create a calculate column instead using DAX below:

Column = IF(Table1[Amount] = 0, Table1[Amount Arch], Table1[Amount])

 

 

Regards,

Jimmy Tao