Variance-
A= sales ytd ( ex: if you are passing current month it would be upto Jun-11-2017.
B=sales for previous year ( this would be sales for jun-2016 entire month, not ytd)
((A-B)/B)*100
Issue is with the calculation of B here. I am able to get the number of days for 'B' here which is the no. of selling/business days from feb-jun 2016 (our fiscal year starts from feb) using
sales <= period number but unable to assign the year here if I use period number. It can be period number of any year. Please see below for the logic i used.
case when VALUEOF("Current_FP") = '@{P1}' THEN
((FILTER("Customer Transactions Fact"."Sales $" USING
("Invoice Post Fiscal Date"."Invoice Post Fiscal Month" = '@{P1}{Jun-2017}'))/ CAST( VALUEOF("SELLING_DAYS_YTD") AS DOUBLE))-
FILTER("Customer Transactions Fact"."Sales $" USING ("Invoice Post Fiscal Date"."Invoice Post Period Number" <= (@{PNum}{5})))
/
FILTER("Customer Transactions Fact"."Sales $" USING ("Invoice Post Fiscal Date"."Invoice Post Period Number" <= (@{PNum}{5}))))*100
else
((FILTER("Customer Transactions Fact"."Sales $" USING ("Invoice Post Fiscal Date"."Invoice Post Period Number" <= (@{PNum}{5})))-
FILTER("Customer Transactions Fact"."Sales $" USING ("Invoice Post Fiscal Date"."Invoice Post Period Number" <= (@{PNum}{5}))))/
FILTER("Customer Transactions Fact"."Sales $" USING ("Invoice Post Fiscal Date"."Invoice Post Period Number" <= (@{PNum}{5}))))*100
end
