Forum Discussion

Dee's avatar
Dee
Helper III
7 years ago
Solved

Measure On Conversion Of Calls

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")))

 

Need Help
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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"
)

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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"
)
    • Dee's avatar
      Dee
      Helper III
      7 years ago

      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