Measure On Conversion Of Calls

[Dee]

Hi all,

Am trying to do a call conversion, that checks if the customer did a purchase 10 days after making a call, the measure is somehow not working well on power bi nor SSAS, someone kindly help me out on that.

=if(ISBLANK(COUNTROWS((FILTER(FILTER(CustomerTransactionsView, CustomerTransactionsView[MobileNo] = Interactions_MobileNo[PhoneNumber]), (CustomerTransactionsView[TransactionDate] >= (Interactions_MobileNo[CreatedOn] && (CustomerTransactionsView[TransactionDate]<  DATEADD(Interactions_MobileNo[CreatedOn],10,DAY)) )))), "NO", "YES")))

[v-frfei-msft · Accepted solution]

Hi @Dee ,

Please have a try. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 =
IF (
    ISBLANK (
        COUNTROWS (
            FILTER (
                CustomerTransactionsView,
                CustomerTransactionsView[MobileNo] = Interactions_MobileNo[PhoneNumber]
                    && CustomerTransactionsView[TransactionDate] >= Interactions_MobileNo[CreatedOn]
                    && CustomerTransactionsView[TransactionDate] < ( Interactions_MobileNo[CreatedOn] - 10 )
            )
        )
    ),
    "NO",
    "YES"
)

[vanessafvg]

@Dee 

  can you share some data and what your data looks like?

[Dee]

The data roughly looks like this.

Table = Customer Transaction View

Column = MOBILE NO

Value         557689321

Table = Interaction Mobile no

Column = phone no

Value         557689321

Table = Customer Transaction View

Column = transaction date

Value        5/2/2017

Table = Interaction Mobile no

Column = created on

Value         4/19/2017