+ Reply to Thread
Results 1 to 4 of 4

DAX Time Calculation to see records Between Specific Time

  1. #1
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Question DAX Time Calculation to see records Between Specific Time

    Hi All,

    Please see in attached Power Pivot Model I need to Identify the records that fall in between two time brackets"
    1. days to filter - Sunday to Thursday & Time to filter 6pm to 6am (next day); and
    2. days to filter - Sunday to Thursday & Time to filter 10pm to 6am (next day).

    Any ideas appreciated.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: DAX Time Calculation to see records Between Specific Time

    We could have two calculated columns to identify the records that fall in each of the two time brackets.

  3. #3
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: DAX Time Calculation to see records Between Specific Time

    HI

    to count no records between Time to filter 6pm to 6am (next day)

    Please Login or Register  to view this content.

    insert a date slicer to select the dates (ie Sunday to Thursday)

  4. #4
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: DAX Time Calculation to see records Between Specific Time

    Thanks for the Codes.

    But I would like to identify the records in each line, if they qualify or not. With a "Yes" or "No" as an example.

    I am not looking for a calculated measure, but a calculated column.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Start time and End time Calculation sheet and uneditable of Time
    By tgray007 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-17-2017, 10:02 AM
  2. Replies: 2
    Last Post: 02-03-2017, 07:39 AM
  3. [SOLVED] Excel calculation for adding time and calculating remaining time
    By mark888 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2015, 06:38 AM
  4. [SOLVED] Time entry on UserForm displaying inccorectly and calculation not working on the time.
    By Colin Smit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-12-2014, 01:21 PM
  5. [SOLVED] Creating a Time elapsed Spread Sheet that records and posts time...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2013, 07:11 PM
  6. Replies: 11
    Last Post: 05-20-2011, 02:09 PM
  7. Specific time period calculation from a time range
    By Khaldon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:44 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1