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.

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Kurumi0418,

         

        Actually, Phil_Seamark's idea works. You can select the value "1" of the filter to get the group. Can you share your expected result?

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Best Regards,

        Dale