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 Tought to say, not sure I have enough context about the data and what you are doing. But I would love it if measures could return tables. Would really help cut down on repeating the same code in multiple places.