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))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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))