old and new customers formula help

[Anonymous]

Hi, am currently using the formula formula 

New New Migrated =

VAR _CloudCheck = LOOKUPVALUE(CustomerOrderItems[Cloud or Prem],CustomerOrderItems[CustomerOrders.1.CustomerID],CustomerOrderItems[CustomerOrders.1.CustomerID],CustomerOrderItems[Cloud or Prem],"Cloud")

VAR _OnPremCheck = LOOKUPVALUE(CustomerOrderItems[Cloud or Prem],CustomerOrderItems[CustomerOrders.1.CustomerID],CustomerOrderItems[CustomerOrders.1.CustomerID],CustomerOrderItems[Cloud or Prem],"On Prem")

RETURN IF(_CloudCheck<>BLANK() && _OnPremCheck <> BLANK(),TRUE(),FALSE())

to work out what of our existing customers are buying another product. My issue is they should only appear as a migration once, not whenver they appear again. So currently if they appear in onprem and cloud thats a migraiton but if they appear onprem and cloud then 6 months later cloud again its couting it as 2 migraitons is there a way to base the migraiton only on the first invoice?

[v-lili6-msft]

HI, @Anonymous 

Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

And from your formula:

New New Migrated =
VAR _CloudCheck =
    LOOKUPVALUE (
        CustomerOrderItems[Cloud or Prem],
        CustomerOrderItems[CustomerOrders.1.CustomerID], CustomerOrderItems[CustomerOrders.1.CustomerID],
        CustomerOrderItems[Cloud or Prem], "Cloud"
    )
VAR _OnPremCheck =
    LOOKUPVALUE (
        CustomerOrderItems[Cloud or Prem],
        CustomerOrderItems[CustomerOrders.1.CustomerID], CustomerOrderItems[CustomerOrders.1.CustomerID],
        CustomerOrderItems[Cloud or Prem], "On Prem"
    )
RETURN
    IF ( _CloudCheck <> BLANK () && _OnPremCheck <> BLANK (), TRUE (), FALSE () )

All the result of each row will return false. we couldn't find out the logic of it.

Please share your logic and expected output based on some sample data.

Best Regards,
Lin