Unable to get date ranges using firstdate

Question

Hi, I have a manually created table where the user will pick from a drop down

I want it to get the correct starting date, depending on what the user clicks on above
In the example above, when I click All Data, the first date in the table appears.
But when I click on any other option here, the card on the right comes up blank. Here's the code I'm using

_1 Start Date =

SWITCH (

SELECTEDVALUE('_CalendarOptions'[Options]),

"All Data", MIN('SingleMultiPageVisits'[MetricDate]),

"Last Month", FIRSTDATE(DATESINPERIOD('SingleMultiPageVisits'[MetricDate], TODAY(), -2, MONTH)),

"This Month", FIRSTDATE(DATESINPERIOD('SingleMultiPageVisits'[MetricDate], TODAY(), -1, MONTH)),

"Last Year", FIRSTDATE(DATESINPERIOD('SingleMultiPageVisits'[MetricDate], TODAY(), -1, YEAR)),

"Year Before That", FIRSTDATE(DATESINPERIOD('SingleMultiPageVisits'[MetricDate], TODAY(), -2, YEAR))

)

Needless to say, I have no idea why this isn't working for the rest of the options.
Would appreciate any help?

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,This is a table visual not a slicer:

When you select the content in the table visual,&nbsp;It will only act as a highlight, without any filtering effect. Please change the table visual into a slicer.

Best Regards,Dino TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Unable to get date ranges using firstdate

2 Replies

Related content

Filter firstdate

Whitelist IP ranges

FIRSTDATE and LASTDATE functions broken?

Unable to upload PBIX files

startofmonth & FirstDate function Issue