Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AKhan
Regular Visitor

Power Bi desktop timeline slicer filter with other

Hi all,

I am a new in power bi desktop,and created a timeline slicer with date field(In-date) and have two  fields,In-date and  Out-date  .

need: filter count of  Out-date  field  with status using In-date field start and end date(means range)

and done following things.

1.got start and end date from In-date field on timeline slicer slicer selection(Created a measure):

 

StartDate = CALCULATE ( MIN( Tour[In-date].[Date]),ALLSELECTED(Tour[In-date].[Date]))

EndDate = CALCULATE ( MAX( Tour[In-date].[Date]),ALLSELECTED(Tour[In-date].[Date]))

 

2.count  using Out-date.

CountTest4 = CALCULATE(COUNT(Tour[In-date].[Date] ),DATESBETWEEN(Tour[Out-date].[Date],StartDate ,EndDate ))

 

table

Status   In-date                      Out-date

Open   20-03-2017             19-03-2017

Open   20-03-2017             20-03-2017

Close   30-03-2017            04-04-2017

 

Timeline slicer date selection from In-date is 19-03-2017 to 20-03-2017 and now filter from Out-date .

result should be:

Status  CountTest4

Open    2

 

 

problem: result is not coming correct.

 

 

thanks

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Hi Xiaoxin Sheng,


Thank you for reply,


But my question is that filter from another table with timeline silcer date range and this already mention query .


I have resolved this problem with create a view of a table.

Thanks

Akram

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @AKhan,

 

Based on test, "datesbetween" function seems not work on dynamic date range.

 

You can try to use below formula to achieve your requirement.

 

CountTest4 = CALCULATE(COUNT('123'[In-date].[Date]),FILTER(ALL('123'),[in-date]>=[StartDate]&&[in-date]<=[EndDate] ))

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi Xiaoxin Sheng,


Thank you for reply,


But my question is that filter from another table with timeline silcer date range and this already mention query .


I have resolved this problem with create a view of a table.

Thanks

Akram

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.