How to generate a new column based on observations in another one

[robdan]

I have the following Table:
GROUP which is a list of all clients

TIME that has as values January, February and December

I need to create another column (or maybe a measure would be better) which assigns "New" to clients which are present only when TIME is equal to December.

I think my dax knowledge is not good enoguh to solve this issue, i guess FILTER would be needed but i'm not sure how to use it
Thanks!

[govindarajan_d · Accepted solution]

Hi @robdan,

Can you try using this measure: 

New Client? = 
VAR __ConditionMet = CALCULATE(
                                COUNTROWS('Sample'),
                                'Sample'[Time] = "December"
                             ) > 0
RETURN
IF(
    __ConditionMet,
    "New",
    BLANK()
)

[Anonymous · Accepted solution]

Hi @robdan 

@govindarajan_d  GOOD ANSWER!

You can also try the following measure:

My sample:

Measure = IF(MAX([Time]) = "December", "New", BLANK())

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[govindarajan_d · Accepted solution]

Hi @robdan,

Can you try using this measure: 

New Client? = 
VAR __ConditionMet = CALCULATE(
                                COUNTROWS('Sample'),
                                'Sample'[Time] = "December"
                             ) > 0
RETURN
IF(
    __ConditionMet,
    "New",
    BLANK()
)