Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    92

    VBA - Copy Paste in last workday

    Hello everybody!


    I'm currently facing a relatively simple problem.
    I have the following table:
    There are values in the Range B2:F2
    Then there are a calender column since A5 - like below

    ...
  2. Replies
    0
    Views
    291

    Count distinct rows with multiple criteria

    Hello everyone!

    I am struggling with a pretty simple problem at the moment.
    I have the following two tables in the data model (power pivot)


    tblGeneral
    ID - Date - Value - Typ:
  3. Replies
    3
    Views
    471

    Re: Power Pivot - COUNT IF

    work perfect!
    thanks
  4. Replies
    3
    Views
    471

    Power Pivot - COUNT IF

    Hey together,

    I am just aiming a pretty simple problem.
    I have the following table:


    <colgroup><col><col><col span="2"></colgroup><tbody>
    DOC
    UNIT
    DATE
  5. Replies
    5
    Views
    584

    Re: Filtering 2018 to Date

    How can I filtering 2018 (total) AND 2019 (until today)?
    I want 01.01.2018 - today.
    Year to day + last year.

    I dont want the dates in future.
    Your approach would display alle dates for 2018 and...
  6. Replies
    5
    Views
    584

    Re: Filtering 2018 to Date

    Ok, and how can I get the rows for 2018 + 2019 to today?
    Just filtering the year is not appropriate
  7. Replies
    5
    Views
    584

    Filtering 2018 to Date

    Hey guys!

    I have in Excel/ Power Query a regular date column (DD.MM.YYYY).
    I would like to filter this column for year 2018 in total and 2019 to date.
    So for today 01.01.2018-05.02.2019.

    Is...
  8. Replies
    4
    Views
    116

    Method 'Range' of object'_Global' failed

    Hey!


    I am using the following code, to jump to the first day of the month.
    The buttons includes the name of the month ("Jan"...).


    It works perfectly at my computer, but not on others....
  9. Replies
    0
    Views
    96

    VBA - Refresh and split tables

    Hey community!

    I've come to the limit again that I have to use VBA. Unfortunately, my abilities with VBA are exhausted.
    I have a file that should overwrite selected tables in new or old Excel...
  10. Re: Function: If and statement with numbers and dates

    Thanks a lot!

    But this approach doesnt work:

    if Date.DayOfWeek([Date], Day.Monday) < 5 then if [Amount] <= #duration (0,8,45,0) then [Amount] else #duration (0,8,45,0) else if...
  11. Replies
    3
    Views
    511

    Re: Power Pivot - hierarchy

    Ok, many thanks!

    So I need just a key table with unique keys, right?
    What is about the hierarchy function?
    I thought this would help. Or is this approach for something different?
  12. Replies
    3
    Views
    511

    Power Pivot - hierarchy

    Hey community!


    I am getting deeper and deeper into the world of Power Query and Power Pivot. It brings a lot of potential and makes my job a lot easier. Currently I am facing the following...
  13. Replies
    4
    Views
    299

    Re: Update various Excel files daily

    Do you know how to save them after the refresh?
  14. Replies
    7
    Views
    251

    Re: Count weekends in a row

    Many thanks!

    Is your approach also without a matrix-function possible?

    Owing to a large number of rows (750k) it is very slowly...
  15. Replies
    7
    Views
    251

    Re: Count weekends in a row

    Thats right
  16. Replies
    7
    Views
    251

    Re: Count weekends in a row

    The ID has worked 3 weekends in a row, so it should be true.
    Or what do you asking for exactly?
  17. Replies
    7
    Views
    251

    Count weekends in a row

    Hey guys!


    I have a table with this format:


    <tbody>
    ID
    Date
    Day
  18. Replies
    4
    Views
    299

    Re: Update various Excel files daily

    Thanks!

    But how can I save the different Excel-files/ Queries?
  19. Refresh several excel-files with own queries

    Hey!




    I have introduced several Excel files in the company, which use Power Query to consolidate different Excel files and prepare them accordingly. The structure is as follows:
  20. Replies
    4
    Views
    299

    Re: Update various Excel files daily

    Yes, thats right.

    This is actually my approch.
    I have 10 files with own PQ.
  21. Replies
    4
    Views
    299

    Update various Excel files daily

    Good day!

    I have about 10 files that I manually open and update daily. Overall, the procedure takes 30 minutes so far.

    Is there any way to outsource this update somehow?
    On a kind server /...
  22. Re: Function: If and statement with numbers and dates

    It works perfect! Thanks a lot!

    Do you know, how to adapt the code on a duration type of values?
    Like: if Date.DayOfWeek([Date], Day.Monday) < 5 then if [Amount] <= 00.07:45:00 then [Amount]...
  23. Function: If and statement with numbers and dates

    Hey!

    Unfortunatelly, I am still not good at defining own functions in power query.
    May someone of you can help me.

    I have the following table:

    Date - Value
    01.01.2018 ...
  24. Re: power Query - If and then else of - statement

    Does someone have any idea?
  25. power Query - If and then else of - statement

    Hey guys!
    I'm trying to map some logic using if then else.I have column "Date" and column "Duration".If the value for Duration is> 0.08: 00: 00 and it is between Mon-Fri, then 0.08: 00: 00 should be...
Results 1 to 25 of 54
Page 1 of 3 1 2 3