Date Diff between Selected Value from Slicer and A date field

[swrlabhe]

Hi PBI Gurus

I have a scenrio where the date is in date range on Sliders and the table have a data with fields having another date.

The date slicer has date field name <System_Date> while the visual have date filed name <Updated_Date>

Now If I Select <System_Date> range from date slicer say 01-Jun-2024 to 30-Jun-2024 it should show below data 

No Of Days shold be calculated based upon the End Date select in date slicer - the Updated_Date in table visual.

Appreciate your help here

[jgeddes]

A measure like the following will work when the table date is not related to the date from the date table.

Measure = 
var _maxDate = 
MAXX(dateTable, dateTable[Date])
var _diff = 
DATEDIFF(SELECTEDVALUE('Table'[DateFromTable]), _maxDate, DAY)
RETURN
_diff

[swrlabhe]

This is just calculating No Of Days but it should also filter the table below , so If I select end date as 30-Jun-2024 the date slider is having properties as before so it shoudl show all data before 30-jun-2024

[swrlabhe]

Thanks it worked as expected

[jgeddes · Accepted solution]

If you want the slicer to also filter the table then you will need to make a relationship between the date table and the fact table.