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

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