Forum Discussion
Operation Last Year vs Current Year using filters
try to calculate automatically (add or sustract) selecting one month in the filters in one table. Need to compare for example sales for one year vs previous year. I has been try with this formula ...
Hi guys,
I'm making this calculation buy seems not working. "Argument 9 in SWITCH function is required"
Basically what I'm doing is that, based on the selection of a specific year, the formula selects a specific sumx
SWITCH(TRUE(),
[Selected Date] = 2025, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY25]),
[Selected Date] = 2026, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY26]),
[Selected Date] = 2027, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY27]),
sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY28]),
)
much appreciated if you guide me.
David