Forum Discussion
Defining Dates for CALCULATE using a parameter and DATESMTD
Metric Current Period = SWITCH('Period Selection'[Period Type Selected],
1, CALCULATE(Transactions[Metric],
DATESMTD(
{
[AsAtDate]
})
)
)
Error: Cannot find t...
Greg_Deckler
Community Champion
Community ChampionAnonymous Probably not, measures can't return tables and DATESMTD wants a table of dates.
Ok to a switched to filters in series for the date table and new measures AsAtYear, AsAtMonth, AsAtQuarter so they only need to be calculated once with data refresh. I've got to wonder if there is a better way to do it that jumps out at you, considering I'm leaping sideways from my expectation that I could create a table from a measure, and still casting off the assumptions I had.
Thanks for your reply as well.