Forum Discussion
Basket Analysis
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
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
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'?
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
What would be the best way to do that?
Hi OpenMike13, as I've done for you is completely fine. It provides you with the ability to use the original column for memberships but also the updated. It's already been done in PowerQuery so there's no code needed in Power BIs front end.