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 them in my formula. please suggest.

 

Formual -:   Planned Counts FY = IF(VW_FI_FREC_InvCount[Planned Count Date] >= VW_FI_FREC_InvCount[StartDate] && VW_FI_FREC_InvCount[Planned Count Date] <= VW_FI_FREC_InvCount[EndDate] ,
IF(YEAR(VW_FI_FREC_InvCount[Planned Count Date]) = YEAR(VW_FI_FREC_InvCount[EndDate]) && YEAR(VW_FI_FREC_InvCount[Planned Count Date]) = YEAR(VW_FI_FREC_InvCount[EndDate]), 1, 0))
 
 
Date Table formula = 
Start Date = CALENDAR("01/01/2015", TODAY())   
 
Thanks.
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))

3 Replies

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

    • 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.