Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Data Manipulation

Hi I have a specific request wherein a finance report needs to be developed where it shows on a daily basis how much amount came into organisation and how much was disbursed. My base table from which...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Create measures as below

     

    Interest=Calculate(Sum(Table[amt]),filter(table,table[Component]="interest")

    TDS on Interest=Calculate(Sum(Table[TDS]),filter(table,table[Component]="interest")

    Gross interest=Calculate(Sum(Table[Total]),filter(table,table[Component]="interest")

    Principle=Calculate(Sum(Table[amt]),filter(table,table[Component]="Principle")

    TDS on Principle=Calculate(Sum(Table[TDS]),filter(table,table[Component]="Principle")

    Gross Principle=Calculate(Sum(Table[Total]),filter(table,table[Component]="Principle")

    Gross total income=sum(Table[Total])

     

    add date column and above measures in matrix.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You can unpivot the 3 value columns by right clicking on the columns:

then close & apply the changes and create a matrix like this:

Afterwards you can remove the subtotals if you like.