Forum Discussion

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
7 years ago

Employee Milestones

I'm looking for format Employee Milestones this way. Script below gives me year of service including anniversary date. How do I make it so if employee anniversary (& keep it in this bucket for 30 day...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi diskovered ,

I have a little confused about your sceanrio.

Do you want to group your data by years? 

Based on your code above, you may could try IF function to achieve that in Power BI.

If it is convenient, could you share some data sample and your desired output in Power BI  so that we could help further on it?

Best  Regards,

Cherry

 

  • diskovered's avatar
    diskovered
    Icon for Helper III rankHelper III
    7 years ago

    Hi Cherry,

     

    Scenario:

     

    Say today is an [employee's] 5th or 10th or 30 year anniversary. I want employee's name shown in their respective year of service area. Second condition is I don't want their names to stay there forever, I only want it there for 30 days after their anniversary date. eg: (Sorry, I can't conveniently share my pbix) Thanks