+ Reply to Thread
Results 1 to 3 of 3

Add custom fields to a table to simulate a pivot table - Power Query

  1. #1
    Registered User
    Join Date
    10-24-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    2

    Add custom fields to a table to simulate a pivot table - Power Query

    Hi,

    I've used Power Query to merge 2 tables and to add multiple custom columns to simulate a pivot table.
    However, I can't seem to add a "Month" filter field like in a normal pivot table.
    Is there a way to do it?

    I've tried to use the pivot table from Excel to do what I'm seeking, however I can't seem to produce what I'm looking for without
    adding formulas next of the pivot table.

    I'm also looking for something dynamic since the data will be updated every week.

    Additional details:
    I'm trying to add the following columns to the pivot table: (Nombre employés, Indisponibilté, Disponibilté, Taux disponibilté (%))

    Thanks.
    Attached Files Attached Files
    Last edited by nathalielesperance; 10-24-2018 at 11:28 AM.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Add custom fields to a table to simulate a pivot table - Power Query

    I'm not exactly sure what you're trying to achieve, but why not use Date as your filter not Month (number)?

    See attached pivot table.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-24-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    2

    Re: Add custom fields to a table to simulate a pivot table - Power Query

    Hi,

    The thing is that the pivot table doesn't have the other columns (Nombre employés, Indisponibilté, Disponibilté, Taux disponibilté (%))
    I'd like to know if there is a way to add them.

    Thanks!

+ 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. POWER Query and Power Pivot Table !!
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2018, 04:09 PM
  2. Power Query and Power Pivot Table
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2018, 06:17 AM
  3. Power Query and Power Pivot Table !!
    By haitham.shop in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2018, 06:15 AM
  4. POWER Query and Power Pivot Table !!
    By haitham.shop in forum Access Tables & Databases
    Replies: 0
    Last Post: 08-06-2018, 05:59 AM
  5. Replies: 15
    Last Post: 03-29-2018, 11:29 AM
  6. [SOLVED] Pivot table from power query
    By pccamara in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 05-17-2017, 10:09 AM
  7. Replies: 4
    Last Post: 06-19-2014, 12:59 PM

Tags for this Thread

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