Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    733

    Re: Aggregate two tables onto one granulity

    Thanks for the replies!

    I dont want a Merge of both tables in one. I am looking for a data modell.
    So, I think a need a reference table with unique values for ID, the skills and the dates.
    The...
  2. Replies
    5
    Views
    733

    Aggregate two tables onto one granulity

    Hello everybody,


    I have two tables in the following format:

    tblSkills:

    <tbody>
    Name
    ID
  3. Replies
    0
    Views
    604

    Table with multiple date columns

    Hey, together


    I have the following table in Excel, which I add in PowerPivot to the data model:


    <tbody>
    ID
    Created
    Started
  4. Thread: IF Clause

    by joslaz
    Replies
    2
    Views
    738

    Re: IF Clause

    It works perfecly! Thanks
  5. Thread: IF Clause

    by joslaz
    Replies
    2
    Views
    738

    IF Clause

    Hello everyone,

    I have the following tabel:


    <tbody>
    Dep
    Area
  6. Replies
    4
    Views
    900

    Re: find nearest date

    Perfect! It works!
    Thanks :)
  7. Replies
    4
    Views
    900

    Re: find nearest date

    Hey jorismoerings!
    Thanks for your approach!

    Is there maybe a sintax issue with RETURN? I put the function into the column in powerpivot. Is that right?
  8. Replies
    4
    Views
    900

    find nearest date

    Hello everyone,

    I am looking for a Lookup-function in PowerPivot/ Dax to get the nearest date for a specific date.

    I have the following two tables:

    TblVal

    <tbody>
    Date
  9. Actual and Budget with different granularity

    Hey, together


    I'm currently facing a small challenge again.I have the following two tables.

    TblActuals

    <tbody>
    Product ID
    Group
  10. Replies
    1
    Views
    133

    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

    ...
  11. Replies
    0
    Views
    354

    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:
  12. Replies
    3
    Views
    528

    Re: Power Pivot - COUNT IF

    work perfect!
    thanks
  13. Replies
    3
    Views
    528

    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
  14. Replies
    5
    Views
    630

    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...
  15. Replies
    5
    Views
    630

    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
  16. Replies
    5
    Views
    630

    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...
  17. Replies
    4
    Views
    126

    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....
  18. Replies
    0
    Views
    118

    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...
  19. 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...
  20. Replies
    3
    Views
    555

    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?
  21. Replies
    3
    Views
    555

    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...
  22. Replies
    4
    Views
    342

    Re: Update various Excel files daily

    Do you know how to save them after the refresh?
  23. Replies
    7
    Views
    272

    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...
  24. Replies
    7
    Views
    272

    Re: Count weekends in a row

    Thats right
  25. Replies
    7
    Views
    272

    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?
Results 1 to 25 of 63
Page 1 of 3 1 2 3