Forum Discussion

Gresi's avatar
Gresi
Frequent Visitor
6 years ago
Solved

Get all Records between two dates based on a slicer selction

Hello at all,   i'm looking for a possibility to get all records between two dates from a slicer.   That's my slicer for selecting min and max-date.     Her two measures for getting min ...
Need Help
  • Gresi's avatar
    Gresi
    6 years ago

    Hi at all,

    thanks for the answers.

    An addendum again.

     

    In the timeline below, the values of both substitutedStart and substitutedEnd are shown.

     

     

     

     

    minDateTime_Selected and maxDateTime_Selected are determined as follows.

     

    In future, however, minDate_Selected and minTime_Selected as well as maxDateSelected and maxTimeSelected should no longer be hard coded but be selectable via a slicer.

     

    My main problem is that I get the values that come from a slicer not in the editor.

    So I can not expect it.

     

    Maybe anyone knows.

     

    Thanks, Gresi

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Gresi 

First delete the relationship so to have model below

Create a caluclated column in "merged task" table

date-time = [Date]&" "&[Time]

Change it to date time format

Then Create measures

Measure =
VAR start1 =
    MIN ( CalendarStartDays[startdate] )
VAR end1 =
    MAX ( CalendarEndDays[enddate] )
RETURN
    IF (
        MAX ( MergedTasks[Date] ) > start1
            && MAX ( MergedTasks[Date] ) < end1,
        1,
        0
    )

In this way, it will filter only 2019/8/6.

 

What do you like for "hour" slicer?

Use the slicer to limit the end hour of the that date(2019/8/6)?

 


Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Gresi's avatar
Gresi
Frequent Visitor
6 years ago

Hi at all,

thanks for the answers.

An addendum again.

 

In the timeline below, the values of both substitutedStart and substitutedEnd are shown.

 

 

 

 

minDateTime_Selected and maxDateTime_Selected are determined as follows.

 

In future, however, minDate_Selected and minTime_Selected as well as maxDateSelected and maxTimeSelected should no longer be hard coded but be selectable via a slicer.

 

My main problem is that I get the values that come from a slicer not in the editor.

So I can not expect it.

 

Maybe anyone knows.

 

Thanks, Gresi