Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Identify Split Transactions

Hello:   I need help with identifying split transactions in Power BI. In Tableau, I was able to develop a worksheet that could identify all potential split transactions by using the following formu...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ，

     

    Create a measure as below:

    Measure = CALCULATE(DISTINCTCOUNT('Table'[Payment Type]),ALLEXCEPT('Table','Table'[Employee name],'Table'[vendor],'Table'[Transaction date]))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Fowmy's avatar
Fowmy
Super User
5 years ago

Hi,

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi!

 

 Unfortunately, I am unable to share the data as it is company sensitive - please refer to the example below. What I am trying to do is identify any potential split transactions. A split transaction is when an employee is submitting expenses through different payment methods to avoid providing a receipt and stay under the policy limit. Please note that in the example below the employee name, vendor, and transaction date are the same. This result would allow us to identify which transactions we need to investigate further. 

 

 

 

Thanks,

 

M

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  Anonymous ，

     

    Create a measure as below:

    Measure = CALCULATE(DISTINCTCOUNT('Table'[Payment Type]),ALLEXCEPT('Table','Table'[Employee name],'Table'[vendor],'Table'[Transaction date]))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you! It seems like I can make it work with this formula 🙂