Forum Discussion

Kurumi0418's avatar
Kurumi0418
Helper 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

5 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft 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
      Helper 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
        Microsoft 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