Forum Discussion

ccsrtw's avatar
ccsrtw
Advocate I
9 years ago

Product Revenue Cannibalization

I'm trying to prove or disprove the notion that one of our products (let's call it "X") is cannabilizing revenue from the others ("Other").     My data model/structure is relatively straightforward...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

ccsrtw,

 

For the first step, instead of measure, you may try adding a calculated table.

  • ccsrtw's avatar
    ccsrtw
    Advocate I
    9 years ago

    Hi v-chuncz-msft,

     

    Appreciate the reply - not sure what that would accomplish? I'm somewhat familiar with the concept of calculated tables, but haven't really worked with them.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi ccsrtw

       

       

      Can you post some sample data on one drive and share the link here and the output expected.

       

       

      Cheers

       

      CheenuSing

      • ccsrtw's avatar
        ccsrtw
        Advocate I
        9 years ago

        Anonymous - sure! I'll mock something up and post later today or tomorrow. Appreciate your reply.