Forum Discussion
Need Help! - Custom Column for Repeating Values
Hi Elaina0907 ,
You can create a calculated column as below to get it, please find the details in the attachment.
Retained to Next Year? =
VAR _aid = 'Table'[Associate ID]
VAR _hcyear = 'Table'[Headcount Year]
VAR _next =
CALCULATE (
MAX ( 'Table'[Associate ID] ),
FILTER (
'Table',
'Table'[Associate ID] = _aid
&& 'Table'[Headcount Year] = _hcyear + 1
)
)
RETURN
IF (
NOT ( ISBLANK ( _next ) ),
"Retained",
IF ( _hcyear IN { 2025, YEAR ( TODAY () ) }, "Not Applicable", "Terminated" )
)
Best Regards
Hi Elaina0907 ,
Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Hi Elaina0907 ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
Hi Elaina0907 ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!