Forum Discussion

gaurav-narchal's avatar
5 years ago
Solved

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

  • PaulDBrown's avatar
    PaulDBrown
    Community 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