Search:

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

Search: Search took 0.00 seconds.

  1. 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. 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. 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. 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...
  5. Thread: Evaluate Time

    by amulder
    Replies
    3
    Views
    534

    Re: Evaluate Time

    Yes correct
  6. Thread: Evaluate Time

    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. 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. 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. 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. 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. 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. 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. 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...
  14. Replies
    0
    Views
    315

    EARLIER Function

    Hi,

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

    DISPATCH_TIME =...
  15. Replies
    0
    Views
    301

    Add a Group Number

    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. 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:


    Employee ID LoginHr LogoutHr
    123 01/01/2017 09:29:31 01/01/2017 17:51:10
    234 01/01/2017 03:11:01...
  17. Replies
    4
    Views
    3,366

    Re: Rank by Date within Group

    THANK YOU! That worked!
  18. 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. 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. 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