Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |