# Search:

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

1. ## Thread: Calculate the average of a distinct count measure

by amulder
Replies
1
Views
422

### Calculate the average of a distinct count measure

Hi,

Can someone please help me with the syntax to find the average of a measure using DISTINCTCOUNT. Here is the syntax of my measure:

Number of Units = DISTINCTCOUNT( LoggedInData[Unit_ID] )...
2. ## Thread: DAX - 15 minute interval question

by amulder
Replies
5
Views
663

### Re: DAX - 15 minute interval question

Sorry, I missed the step of creating the Logged In Data table. I am trying to create it now but am getting the following error message:

There's not enough memory to complete this operation....
3. ## Thread: DAX - 15 minute interval question

by amulder
Replies
5
Views
663

### Re: DAX - 15 minute interval question

Thanks for this. I need to take it one step further though and also count the unit as "Logged In" if it logged in during a previous time block and is still logged in. So for example, if unit 101...
4. ## Thread: DAX - 15 minute interval question

by amulder
Replies
5
Views
663

### DAX - 15 minute interval question

Hi there,

I have a dataset that has a Car ID (Unit ID), the time (and date) the driver logged in and the time (and date) the driver logged out. I am trying to calculate the number to unique...

by amulder
Replies
3
Views
534

Yes correct

by amulder
Replies
3
Views
534

### Evaluate Time

Hi,

I am trying to evaluate a time value in a query with a calculated column. I have 2 columns; Login Polling Interval and Logout Polling Interval. If the record is considered logged in at...
7. ## Thread: How to count the number of Mondays in a date range

by amulder
Replies
3
Views
662

### Re: How to count the number of Mondays in a date range

I need the day of the week to adjust automatically when I add it to my matrix but only be filtered by the column not the row. Right now I'm just using a simple COUNT('Date'[DOW) which works on its...
8. ## Thread: Absolute References in Power BI?

by amulder
Replies
1
Views
403

### Absolute References in Power BI?

Hi,

Is there a way to do absolute references in Power BI like there is in Excel. Essentially I want to be able to always reference a single cell value in a table visual.

Thanks!
9. ## Thread: How to count the number of Mondays in a date range

by amulder
Replies
3
Views
662

### How to count the number of Mondays in a date range

I've been searching and searching but I can't seem to find the syntax for a measure that will allow me to count the number of Mondays within a date range. The date range will be selected through a...
10. ## Thread: How to create a static column or row headings in a table in power bi

by amulder
Replies
0
Views
377

### How to create a static column or row headings in a table in power bi

Hi,

Is it possible to create static column or row headings in a table or matrix visual? I'm trying to convert an Excel spreadsheet to Power BI and am missing some of Excel's functionality in...
11. ## Thread: Calculate with filter causing out of memory error

by amulder
Replies
0
Views
347

### Calculate with filter causing out of memory error

Hi,

I have the following calculated column, that will calculate correctly and quickly.

Column1 = CALCULATE(
COUNTROWS(Query1),
FILTER(Query1,Query1[STATUS]="LN"),...
12. ## Thread: Data different in Power Query than in Data view

by amulder
Replies
1
Views
364

### Re: Data different in Power Query than in Data view

I have found the problem was due to rounding of milliseconds in power bi. I updated my source Excel file to round to the nearest 15 minute block and it resolved the issue.
13. ## Thread: Data different in Power Query than in Data view

by amulder
Replies
1
Views
364

### Data different in Power Query than in Data view

Hi,

For some reason my data is changing between Power Query and data view. My source file is a simple Excel table. I import this into Power Query without issue and the data looks exactly the...

by amulder
Replies
0
Views
315

### EARLIER Function

Hi,

I'm a bit confused by the EARLIER function. Here is my formula:

DISPATCH_TIME =...

by amulder
Replies
0
Views
301

Hi,

I am trying to create a new column in Power BI that will allow me to group my data by a subset of the entire table. Here is what I am trying to accomplish.

<tbody>
Event Number
Unit...
16. ## Thread: Counting employees logged in during specific hours for a specific amount of time

by amulder
Replies
1
Views
308

### Counting employees logged in during specific hours for a specific amount of time

Hi,

I am banging my head against the wall on this issue. Below is my sample dataset:

123 01/01/2017 09:29:31 01/01/2017 17:51:10
234 01/01/2017 03:11:01...
17. ## Thread: Rank by Date within Group

by amulder
Replies
4
Views
3,366

### Re: Rank by Date within Group

THANK YOU! That worked!
18. ## Thread: Rank by Date within Group

by amulder
Replies
4
Views
3,366

### Re: Rank by Date within Group

Hi,

Thanks for this, I still am not able to get it working. Are you able to provide the syntax using my column names in this scenario?

Thanks,

Ashlee
19. ## Thread: Rank by Date within Group

by amulder
Replies
4
Views
3,366

### Rank by Date within Group

I am trying to create a DAX calculation in PowerPivot that will give me a rank based upon a date within a group. Here is a sample of my data:

Event# Unit Arrive_Time
1234 100 2017-01-01...
20. ## Thread: Create a group number that advances when value is found

by amulder
Replies
7
Views
491

### Create a group number that advances when value is found

I have the following data:

<tbody>
Event ID
Vehicle
Status Code

P16039954
Results 1 to 20 of 20