Filter only works when field is in table
I have a Power BI report in which I have created a "dynamic" filter.
Basically I prompt for a date and then figure out a date range based on the selected date, using logic:
dtRngVar =
var startdate = SOLVE FOR STARTDATE
var enddate = SOLVE FOR ENDATE
IF(SELECTEDVALUE(DateTable[FISCAL_DATE]) IN DATESBETWEEN(DateTable[FISCAL_DATE],_startdate,_enddate),1,0)
I then apply a filter to my table where dtRngVar = 1.
This works fine as long as I have DateTable[FISCAL_DATE] in my table. The minute I take it out, I get nothing.
I'd like to see something like:
REGION...STATE...NETSALES...REVENUE, etc - for my dynamic range, but without the individual date rows.
Any thougtht?