topic How to generate a new column based on observations in another one in DAX Commands and Tips

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

robdan — Tue, 13 Feb 2024 16:44:52 GMT

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!

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

govindarajan_d — Tue, 13 Feb 2024 19:09:03 GMT

Hi robdan,

Can you try using this measure:

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

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

Anonymous — Wed, 21 Feb 2024 09:57:41 GMT

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.