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] )
)
Martin_Bruwer's avatar
Martin_Bruwer
Frequent Visitor
8 years ago

Thank you both,

 

I am trying the DAX method at the moment, seems to be working just doing some testing and I'll accept as solution. Will try the Query solution soon after.

 

Thank you

 

Martin

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Here is an alternative DAX column.  I found the FIRSTNONBLANK has issues with some datasets

     

    Column = 
    MAXX(
        FILTER(
            'Table1',
            'Table1'[Transaction Code] = EARLIER('Table1'[Transaction Code]) 
            ),
        [How Paid]
        )