Need help on DAX Calculated Column

[Sashwato]

Hello all,

I am working on a test file to replicate a solution. I have the following columns in my model. The image is displayed below:

I would like to know if we can have Username - Danny be displayed just once (if record available) for every instance of a Month end period. For example - here for period ending 1/31/2021 - we have Danny thrice in Username column. Can we show it just once for any EARLIEST instance he is market on a Client project? We need to keep in mind, whenever the new period starts - Danny becomes eligible to be counted again if any one instance is found.

Please let me know if any solution is available. Any help is appreciated!

Regards!

Sas

[v-yalanwu-msft · Accepted solution]

Hi, @Sashwato ;

You could a create a calculate column as follows:

Merged = IF([Client]=CALCULATE(MIN([Client]),ALLEXCEPT('Table','Table'[Date],'Table'[Username])),[Username])

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@Sashwato 

Could you please provide the expected output in details?

maybe you can create a new table?

summarize(table, merged)