Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    302

    Re: Determination of the absence rate

    With the following function the pivot contains also the blanks.

    =( (
    COUNTROWS (
    FILTER (
    'Process Staffing Total';
    'Process Staffing Total'[Status]
    IN {
    "U";
    "P"
  2. Replies
    3
    Views
    302

    Re: Determination of the absence rate

    Hey Matt, thanks for your approach!

    I have worked out an approach like that:



    So this functions sums all rows, that contains U or P (addional day off) and dived the sum by the workday factor...
  3. Replies
    3
    Views
    302

    Determination of the absence rate

    Hello everybody,


    I am currently trying to determine from the data model, how high the absence rate for the individual weeks or months.
    So far, I've just added the factor to the pivot calendar,...
  4. Replies
    5
    Views
    830

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

    Aggregate two tables onto one granulity

    Hello everybody,


    I have two tables in the following format:

    tblSkills:

    <tbody>
    Name
    ID
  6. Replies
    0
    Views
    674

    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
  7. Thread: IF Clause

    by joslaz
    Replies
    2
    Views
    792

    Re: IF Clause

    It works perfecly! Thanks
  8. Thread: IF Clause

    by joslaz
    Replies
    2
    Views
    792

    IF Clause

    Hello everyone,

    I have the following tabel:


    <tbody>
    Dep
    Area
  9. Replies
    4
    Views
    953

    Re: find nearest date

    Perfect! It works!
    Thanks :)
  10. Replies
    4
    Views
    953

    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?
  11. Replies
    4
    Views
    953

    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
  12. 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
  13. Replies
    1
    Views
    148

    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

    ...
  14. Replies
    0
    Views
    369

    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:
  15. Replies
    3
    Views
    583

    Re: Power Pivot - COUNT IF

    work perfect!
    thanks
  16. Replies
    3
    Views
    583

    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
  17. Replies
    5
    Views
    655

    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...
  18. Replies
    5
    Views
    655

    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
  19. Replies
    5
    Views
    655

    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...
  20. Replies
    4
    Views
    129

    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....
  21. Replies
    0
    Views
    124

    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...
  22. 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...
  23. Replies
    3
    Views
    566

    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?
  24. Replies
    3
    Views
    566

    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...
  25. Replies
    4
    Views
    357

    Re: Update various Excel files daily

    Do you know how to save them after the refresh?
Results 1 to 25 of 66
Page 1 of 3 1 2 3