Forum Discussion
Power BI Data Manipulation
- Anonymous6 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.
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.
- Anonymous6 years agoNot applicable
Thanks a lot Anonymous !!!