Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have Trasaction log for invoices of different type and payments coming in. I need to see if payments per CaseID are bigger then Invoices for type 1, and for how much. And I'm stuck. Pls help. Thanks
Solved! Go to Solution.
Thanks for effort, solution to problem is at this link Final Word On Measure Totals.
Hi @Anonymous,
Based on my test, you could refer to below measures:
Payment = CALCULATE(AVERAGE(Table1[Amount]),FILTER('Table1','Table1'[CaseID]=MAX('Table1'[CaseID])&&'Table1'[TypeOfTransaction]="PAYMENT"))
Invoice = CALCULATE(AVERAGE(Table1[Amount]),FILTER('Table1','Table1'[InvoiceType]=1&&'Table1'[TypeOfTransaction]="INVOICE"))
Difference = [Payment]-[Invoice]
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks for effort, solution to problem is at this link Final Word On Measure Totals.
would you be able to share some sample data to work this out ?
link is above tekst.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |