I am trying to find number of days between two dates based on a slicer.
I have a table visual which shows the data based on given date slicer.
I have a date column called "Sampled_date", "Template" which has 260000 rows. I am using a slicer which has "Sampled_date" and passing the dates 6/1/2023 to 9/8/2023. I need to find the number of days between given dates in a slicer. I have the Template ID's which are having data only for some dates. But i need to get 99 in each and every case in the table regardless of the data present for the dates. For suppose if i apply the slicer and see the result i am getting 6 as data for one "Template" is having only from 6/1/2023 to 6/6/2023 but i need to see 99 even in that case also.
I tried this formula but it didn't work.
Days =
var startdate = MIN([sampled_date])
var enddate = MAX([sampled_date])
return DATEDIFF(startdate,enddate,DAY)
This formula is taking only min and max for the template data based on dates and showing result but i need to get from 6/1/2023 to 9/8/2023 as 99 for every record.
Please suggest me a solution.It's urgent.
@Ritaf1983
@lbendlin
@amitchandak
@Anonymous
@littlemojopuppy
@mattiasdesmet
@Roy_Verharen
@bcdobbs
@Aleksandra_MLT
@TomMartens
@Ahmedx
@Anonymous
