+ Reply to Thread
Results 1 to 4 of 4

power query - checks which work orders are charged with overheads over two days

  1. #1
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    power query - checks which work orders are charged with overheads over two days

    Hey

    I have a table of expenses by work order

    The table is divided according to direct expenses and overheads that are charged each day

    I want to issue a report that checks which work orders are charged with overheads over two days where there were no direct costs

    I would appreciate any ideas on how to do this

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,914

    Re: power query - checks which work orders are charged with overheads over two days

    Where have you mocked up your expected results?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    Re: power query - checks which work orders are charged with overheads over two days

    Attachment 861891

    A partial example of some results in the report

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,914

    Re: power query - checks which work orders are charged with overheads over two days

    I aksed for a mock-up of the results that you want.

+ 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. [SOLVED] Count days between two dates in power query
    By Undo in forum Excel General
    Replies: 1
    Last Post: 12-03-2021, 01:15 PM
  2. Power Query M - Filter last two days
    By Saint_jordi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2021, 04:19 AM
  3. [SOLVED] Power query - Days range issue
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2021, 07:38 AM
  4. Days function in Power Query
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2020, 10:23 AM
  5. Find Each Days Orders by Associate ID, input into Master Orders COmpleteWorksheet
    By bbell2219 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2016, 02:14 AM
  6. [SOLVED] Using sum product to show average number of days for closed work orders
    By mmccra2858 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2014, 06:42 AM
  7. Average of work orders per business days
    By OrlandoFreeman in forum Excel General
    Replies: 13
    Last Post: 07-04-2006, 07:15 AM

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