Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
6 years ago
Solved

Move values from columns to row

I have Table1 I need lookup values from DokNr which is equal to ApNr and return sum from DebSum to CredSum Expected result:      
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

Analitika's avatar
Analitika
Post Prodigy
6 years ago

debSum is a measure not column

amitchandak's avatar
amitchandak
Super User
6 years ago

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