Search:

Type: Posts; User: Excel_ZM; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    9
    Views
    459

    Re: Change Data Structure

    That's just what I needed.
    Thank you!
  2. Replies
    9
    Views
    459

    Re: Change Data Structure

    like this?



    let
    Source = Excel.Workbook(File.Contents("C:\Users\user_X\Desktop\Book1.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Changed...
  3. Replies
    9
    Views
    459

    Re: Change Data Structure

    I pasted this into the advanced editor and it didn't work. Do you know what I am doing wrong here? I'm relatively new to power bi.


    let
    Source =...
  4. Replies
    9
    Views
    459

    Change Data Structure

    Hello,

    I was looking to do a Power Bi but the excel file that I am using has data in an unfriendly way for Power Bi

    Current data structure


    <tbody>
  5. Re: If column is not empty, return values from other columns in same row.

    Try adding a field that is a sum field. If the sum field is blank, then it wont be in the snapshot.
  6. Power-Pivot - One to Many Relationship - Can this only be done in Access?

    I have two tables (see below). I am trying to get my power-pivot to match what I did in Access, but it is not working.

    It is a one to many relationship. One Project can have many Services.
    ...
  7. Replies
    3
    Views
    160

    Re: Create Pivot Table using VBA

    Perfect. That worked.
    Thank you Sektor!
  8. Replies
    3
    Views
    160

    Create Pivot Table using VBA

    Does anyone know why my code won't create a Pivot Table?
    Thanks

    Sub create_pivot_table()


    mc = Range("A1000000").End(xlUp).Row
    mcc = Range("XFC1").End(xlToLeft).Column
  9. Replies
    9
    Views
    229

    Re: Combine VLookups and MAX/MIN functions?

    Thanks again Weazel. I'll use the max and if combination.
  10. Replies
    9
    Views
    229

    Re: Combine VLookups and MAX/MIN functions?

    Aladin,

    yours did not work for me. maybe it's because I'm on excel 2010? I only see MAX and MAXA, MIN and MINA as options.
  11. Replies
    9
    Views
    229

    Re: Combine VLookups and MAX/MIN functions?

    I never used the aggregate function before. I will look into this more.
  12. Replies
    9
    Views
    229

    Re: Combine VLookups and MAX/MIN functions?

    It worked!
    Thank you :)
  13. Replies
    9
    Views
    229

    Combine VLookups and MAX/MIN functions?

    Does anyone know how to combine vlookups and max/min functions?

    Below is an example of my data.


    <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
    Data Sample
  14. Replies
    5
    Views
    6,001

    Re: Subtotals in Pivot Charts?

    It's a shame that I need a second PT just for the subtotal.
    Or I could trick the pivot chart by adding the subtotals to the source table.
  15. Replies
    5
    Views
    6,001

    Re: Subtotals in Pivot Charts?

    The Analyze tab does not show a subtotal option. Am I missing something?
  16. Replies
    5
    Views
    6,001

    Re: Subtotals in Pivot Charts?

    Basely, I would like a bar in the chart that shows
    2014: 75
    2015: 76

    So maybe it is a grand total? Not subtotal?
  17. Replies
    5
    Views
    6,001

    Subtotals in Pivot Charts?

    I know you can add subtotals in pivot tables, but can you add subtotals in pivot charts?

    Below is a small sample data. I would like a subtotal in chart for the Report Year.
    Thank you.

    Report...
  18. Replies
    4
    Views
    414

    Re: Get number of columns?

    I should have known to do that. :stickouttounge:
    I've used Macro Recorder before.
  19. Replies
    4
    Views
    414

    Re: Get number of columns?

    It worked. Thank you!
    I should have checked the members of 'XIDirection' :laugh:
  20. Replies
    4
    Views
    414

    Get number of columns?

    Does anyone know how to get the second line of code to work like the first one?

    This one works.
    LASTROW = Range("a1000000").End(xlUp).Row

    This one does not work.
    LASTCOLUMN =...
Results 1 to 20 of 20