The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
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
Proud to be a Super User!
Paul on Linkedin.
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
Proud to be a Super User!
Paul on Linkedin.