Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Parameter as Tableau

Hello Team,   I have two date parameters 1. Start Date and 2. End date, both are dates and need to be used in the below formula to get counts. I have created a date table as below but i can't use t...
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , this how you can use two dates selected in slicer

    Measure =
    var _max = maxx(allselected('Date'),'Date'[Date])
    var _min = minx(allselected('Date'),'Date'[Date])
    return
    calculate(count(Table[value]),filter(All(Table),Table[date] <=_max && Table[account creation date] >=_min))

     

    Measure =
    var _max = maxx(allselected('Date'),'Date'[Date])
    var _min = minx(allselected('Date'),'Date'[Date])
    return
    calculate(count(Table[value]),filter(Allselected(Table),Table[date] <=_max && Table[date] >=_min))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak  Thanks but my data source does not have start and end date, it just custom date range to be used as a reference in the filter to filter certain period  by the user.