Move values from columns to row

[Analitika]

I have Table1

I need lookup values from DokNr which is equal to ApNr and return sum from DebSum to CredSum

Expected result:

[v-xicai · Accepted solution]

Hi @Analitika ,

You may create measure like DAX below.

CredSum= CALCULATE(Table1[DebSum],FILTER(ALLSELECTED(Table1), Table1[DokN] =MAX(Table1[ApNr])))

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Analitika , Try a new column

sumx(filter(table, [AprNo] = earlier([DocNo])),earlier([debSum]))

or

sumx(filter(table, [AprNo] = earlier([DocNo])),([debSum]))

[Analitika]

debSum is a measure not column

[amitchandak]

@Analitika ,Can you share sample data and sample output in table format?