question

PeterOtt-2483 avatar image
0 Votes"
PeterOtt-2483 asked

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?

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers