Add conditional columns in the existing table using DAX

[tjrosario]

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)

Model	Category	Active/Expired
HM400	Premium Pro	Active
HM400	Premium	Active
HM400	Basic	Expired

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

Model	Category	Active/Expired	Basic	Premium	Premium Pro
HM400	Premium Pro	Active	No	Yes	Yes
HM400	Premium	Active	No	Yes	Yes
HM400	Basic	Expired	No	Yes	Yes

Hoping someone can help me with this.

[Anonymous]

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

[Pragati11]

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