Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add filter button for specific time range

Hello,     I want to add filter button to my report. Like this:   Between 07:05 - 15:20  Shift 1 Between 15:20 - 23-25 Shift 2 Between 23:35 - 07:05 Shift 3   Can you please help me? ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi Anonymous ,

    Test the below dax to create a new column:

    Vardiya = 
VAR hour =
    HOUR ( Sayfa1[Tartim_Bitis] )
VAR MINUTE =
    MINUTE ( Sayfa1[Tartim_Bitis] )
VAR test =
    FORMAT ( Sayfa1[Tartim_Bitis], "hh:mm:ss" )
RETURN
    IF (
        test >= "07:05:00"
            && test < "15:20:00",
        "Shift1",
        IF ( test >= "15:20:00" && test < "23:25:00", "Shift2", "Shift3" )
    )

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

     

     

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Anonymous ,

Test the below dax to create a new column:

Vardiya = 
VAR hour =
    HOUR ( Sayfa1[Tartim_Bitis] )
VAR MINUTE =
    MINUTE ( Sayfa1[Tartim_Bitis] )
VAR test =
    FORMAT ( Sayfa1[Tartim_Bitis], "hh:mm:ss" )
RETURN
    IF (
        test >= "07:05:00"
            && test < "15:20:00",
        "Shift1",
        IF ( test >= "15:20:00" && test < "23:25:00", "Shift2", "Shift3" )
    )

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello v-luwang-msft 

 

Thank your for help ðŸ˜˜