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] )
)
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

In Power Query

 

1. Dupicate the table

2. Group the new table by Transaction code and add an aggregation to be MAX over column How Paid

3. Merge the new table into the orignal table joining on Transaction code.

 

I have attached a sample PBIX File