Forum Discussion

aabi's avatar
aabi
Icon for Helper I rankHelper I
4 years ago
Solved

New table from existing table with calculate columns

Hello all   I have the a dataset which contains all subscriptions statuses for all users. I need to know for each user their status which is based on their subscription status paid/trial/free/expi...
Need Help
  • mussaenda's avatar
    mussaenda
    4 years ago

    Hi aabi ,

     

    This may not be the best solution but it achieved what you need.

     

    hope this helps.

     

aabi's avatar
aabi
Icon for Helper I rankHelper I
4 years ago

Hi mussaenda 

 

Thank you for this! It does work and it seems as a nice solution!
I will try to understand it a bit more as I'm not that good M-Query.

I have actually managed to do this on my own using DAX.
I made a new table with all users (dinstict) and then used 2 calculate columns with SWITCH(true) to mark each user Paid/Trial/Free/Expired, then mark each user as Type 1, Type 2 or Both.
Then a third column assesing for all possible combinations of the 2 other Switch columns!

 

But still I appreciate your time for making a solution!