Date Parameter as Tableau

[Anonymous]

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.

[amitchandak · Accepted solution]

@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]

@Anonymous , refer if this blog can help you how to deal with two dates

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

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