Forum Discussion
Measure Help!
Dear All
I am seeking your help to show “error” on all Invoices in PowerBi if Payment or Batch No is updated twice in the same Invoice number.
So basically “Per Invoice” Payment & Batch No should be always updated once else it should show as an Invoice error.
Order Reference and Account Number can be shown multiple times per Invoice. Can I achieve this using a Measure?
Please click here to access the sample report.
Thank you in advance.
Gaurav
This is as far as I've got:
What criteria do you wish to identify the valid row for each duplicate (which you have formatted as green)?
I've attached the sample PBIX file for you
1 Reply
- PaulDBrownCommunity Champion
This is as far as I've got:
What criteria do you wish to identify the valid row for each duplicate (which you have formatted as green)?
I've attached the sample PBIX file for you