Forum Discussion

Martin_Bruwer's avatar
Martin_Bruwer
Frequent Visitor
8 years ago
Solved

Populate a new calculated column with data from within the same table DAX or M?

Evening All,   I have a scenario where I have appended three data tables together, each table has a field which the others need, but don't have naturally, for example a 'How Paid'. This field exist...
Need Help
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Martin_Bruwer

     

    Try this column

     

    Column =
CALCULATE (
    FIRSTNONBLANK ( Table1[How Paid], 1 ),
    ALLEXCEPT ( Table1, Table1[Transaction Code] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi Martin_Bruwer

 

Try this column

 

Column =
CALCULATE (
    FIRSTNONBLANK ( Table1[How Paid], 1 ),
    ALLEXCEPT ( Table1, Table1[Transaction Code] )
)