Forum Discussion

Kurumi0418's avatar
Kurumi0418
Icon for Helper I rankHelper I
8 years ago

Only show time range

  Dear all sirs.   I have Question need help :    Sample as blow :    1. I want only 5/17 07:30 ~ 5/18 07:30 Datatime range and auto refresh by this setting.   How can I do DAX?
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Do you mean to actually filter so only data in that date range is read into the model from the data source? (DAX can't do this)

 

Or do you mean you just want your report to be filtered to only show data in that date range? (DAX can do this)

 

 

  • Kurumi0418's avatar
    Kurumi0418
    Icon for Helper I rankHelper I
    8 years ago

    Hi Phil,  NO2.

     

    I just want update data from every Last day 07:30 am to Today 07:30 am.

     

    Now I just use manaul update date range as blow:

     

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      HI Kurumi0418

       

      Please add the following column to the table that has your date/time value

       

      Column Filter = 
VAR StartDate = TODAY() - 1 + TIME(7,30,0) 
VAR EndDate = TODAY() + + TIME(7,30,0)
RETURN 
    IF(
        'Dates'[Date and Time]>=StartDate && 
        'Dates'[Date and Time] < EndDate,
        1,
        0
        )

      Then drag this to your Visual, Page or Report filter and set that it must = 1

       

      Each day it will roll forward.  I have attached a PBIX File

       

       

      • Kurumi0418's avatar
        Kurumi0418
        Icon for Helper I rankHelper I
        8 years ago

        Phil_Seamark

         

        Can not used.

         

        My Date column : DATE 

        I just want create group by range time at Last day 0730 pm to today 0730 am.

         

        Thanks.