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 report needs to be pulled looks like below :

 

My output format should look like below : 

 

With the matrix visual, I am able to achieve below but can someone help me achieve the final result.

Please help GilbertQ 

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.

3 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

      Thanks a lot Anonymous  !!!