Forum Discussion

tjrosario's avatar
tjrosario
Frequent Visitor
5 years ago

Add conditional columns in the existing table using DAX

Hello,

 

I would like to ask how is it possible to create in DAX below table.

Sorry, I cannot really explain how should I want it so I gave a table below and also a beginner with DAX and PowerBI

 

From: (current table values)

ModelCategoryActive/Expired
HM400Premium ProActive
HM400PremiumActive
HM400BasicExpired

 

To: (what I would like to) Take note that I would like to create a calculated column for Basic, Premium, and Premium Pro

ModelCategoryActive/ExpiredBasicPremiumPremium Pro
HM400Premium ProActiveNoYesYes
HM400PremiumActiveNoYesYes
HM400BasicExpiredNoYesYes

 

Hoping someone can help me with this.

Need Help
Show and Tell

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi tjrosario ,

     

    What is the logic behing these new columns? How are they calculated?

    I am not able to understand the calculation just seeing your Inout data and output data.

     

    Thanks,

    Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI tjrosario,

    Any detailed process logic or conditions used to help group these records? Did you have a mapping table for grouping these records? Please share some more detailed information to help us clarify your requirement and test coding formula.

    How to Get Your Question Answered Quickly

    Regards,
    Xiaoxin Sheng