Forum Discussion
Need help on DAX Calculated Column
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
Hi, Anonymous ;
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.
2 Replies
Anonymous
Could you please provide the expected output in details?
maybe you can create a new table?
summarize(table, merged)
Hi, Anonymous ;
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.
