Forum Discussion

OpenMike13's avatar
OpenMike13
Frequent Visitor
4 years ago
Solved

Basket Analysis

Hello i have a table that has a membership rate purchased by a contact and has a monthly date if the contact has a membership for the countdate.     ContactID Countdate Ratename 1 1/15/20...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi OpenMike13 

     

    Is "Ind. Membership" a type of membership as it is based in the Ratename column?

     

    I've put together a PBIX with a few mods that align with the table in your post but just unsure if it's what you were wanting.

     

    Let us know if it's not! 🙂

     

    Theo

     

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi OpenMike13 

 

Is "Ind. Membership" a type of membership as it is based in the Ratename column?

 

I've put together a PBIX with a few mods that align with the table in your post but just unsure if it's what you were wanting.

 

Let us know if it's not! 🙂

 

Theo

 

  • OpenMike13's avatar
    OpenMike13
    Frequent Visitor
    4 years ago

    Thanks for the quick response.

     

    Ind. Membership is a type of membership but its a basic membership the gold and deluxe are upgraded memberships. I see you added a column to parse out the deluxe and gold. Would this be the route to go to find what tier they upgraded to from the original 'Ind. Membership'?

    • TheoC's avatar
      TheoC
      Community Champion
      4 years ago

      Hi OpenMike13 

       

      To be honest, I only did that because that is what I saw in your requirement to get the output you needed. However, it would very much achieve exactly what you've raised as well (i.e. upgraded memberships).

       

      Hope that helps 🙂

      Theo

       

      • OpenMike13's avatar
        OpenMike13
        Frequent Visitor
        4 years ago

        What would be the best way to do that?