Hello Gurus,
Stuck in to create a Variable in IDT for YTD to find Year to date value for a Measure .
Suppose I want how much Quantity ordered till date that will be entered like To Date will be prompted and from date will give date as per the selection of to date.
I have time_Key string value for date and measure value is Quantity.
And I want to create a variable for Year to date.
Note:- TO date will be any date like , 12 march 2015.(Not Current Date).
Please help me create a variable according to this scenario.
Backend DB is SqlServer.