# Search:

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

Page 1 of 3 1

1. ## Thread: Determination of the absence rate

by joslaz
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. ## Thread: Determination of the absence rate

by joslaz
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. ## Thread: Determination of the absence rate

by joslaz
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. ## Thread: Aggregate two tables onto one granulity

by joslaz
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. ## Thread: Aggregate two tables onto one granulity

by joslaz
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. ## Thread: Table with multiple date columns

by joslaz
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

by joslaz
Replies
2
Views
792

### Re: IF Clause

It works perfecly! Thanks

by joslaz
Replies
2
Views
792

### IF Clause

Hello everyone,

I have the following tabel:

<tbody>
Dep
Area
9. ## Thread: find nearest date

by joslaz
Replies
4
Views
953

### Re: find nearest date

Perfect! It works!
Thanks :)
10. ## Thread: find nearest date

by joslaz
Replies
4
Views
953

### Re: find nearest date

Hey jorismoerings!

Is there maybe a sintax issue with RETURN? I put the function into the column in powerpivot. Is that right?
11. ## Thread: find nearest date

by joslaz
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. ## Thread: Actual and Budget with different granularity

by joslaz
Replies
1
Views
556

### 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. ## Thread: VBA - Copy Paste in last workday

by joslaz
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. ## Thread: Count distinct rows with multiple criteria

by joslaz
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. ## Thread: Power Pivot - COUNT IF

by joslaz
Replies
3
Views
583

### Re: Power Pivot - COUNT IF

work perfect!
thanks
16. ## Thread: Power Pivot - COUNT IF

by joslaz
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. ## Thread: Filtering 2018 to Date

by joslaz
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. ## Thread: Filtering 2018 to Date

by joslaz
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. ## Thread: Filtering 2018 to Date

by joslaz
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. ## Thread: Method 'Range' of object'_Global' failed

by joslaz
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. ## Thread: VBA - Refresh and split tables

by joslaz
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. ## Thread: Function: If and statement with numbers and dates

by joslaz
Replies
4
Views
666

### 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. ## Thread: Power Pivot - hierarchy

by joslaz
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. ## Thread: Power Pivot - hierarchy

by joslaz
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. ## Thread: Update various Excel files daily

by joslaz
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