Hi Everyone,
As a newbie in Power Query world, I stucked on a simple "if" formula actually.
I am trying to add a custom column formula to filter my "Employment Start Date" column. With an example : If the employee started 01.01.2017, manager should make a meeting on 1 April 2017. And I need to send a reminder a month ago on 1 March 2017 (today date) as HR.
So, I need to write a query to filter the hire dates in an active employee report to find out the right population. (in this case the ones who started on 1.1.2017, if today is 1 March 2017) Since I will do this everymonth, the filter date will be change. On the other hand, sometimes since the first of the day is sunday or saturday, start date can be 2nd or 3rd. So, I need to see who has 2 months tenure including the first week of that month. (I need to filter people who has start dates 1.1.2017, 2.1.2017,3.1.2017 start dates)
Hope its clear. Let me know if you need something.
I write this but, it is not showing me the exact population.
=if [Rehire Dt] > Date.AddWeeks(Date.From(DateTime.LocalNow()),-8) then "Y" else "N"
Thank you very much
Orhan
Bookmarks