+ Reply to Thread
Results 1 to 2 of 2

Power query formula

  1. #1
    Forum Contributor
    Join Date
    11-01-2016
    Location
    Prague
    MS-Off Ver
    2013
    Posts
    121

    Power query formula

    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

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Power query formula

    Would be easier if you can show us some example data, with your expected results (mocked up).
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  2. [SOLVED] Change data structure using Formula or Power Query ( Get & Transform)
    By chullan88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2017, 02:58 AM
  3. Power Query Formula/Syntax
    By mielkew27 in forum Excel General
    Replies: 2
    Last Post: 04-09-2017, 11:44 PM
  4. How do I get my formula to work in a power query
    By Justair07 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-22-2016, 10:34 AM
  5. Help with Power Query Custom Column Formula
    By travis.cook21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-16-2016, 01:45 PM
  6. [SOLVED] Formula Creation with Power Query
    By Bhalbert in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2016, 01:11 PM
  7. [SOLVED] Is there a way to add a normal excel formula to a Power Query Table
    By beaglesBuddy in forum Excel General
    Replies: 1
    Last Post: 07-09-2016, 04:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1