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
Icon for Microsoft Employee rankMicrosoft 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]
        )