I have a data sheet (Stocklist) with example data and less columns
I made in Data Manager a new measure YTD, but I can't find the right expression for a YTD
Can anyone help me out on this, I included the data and the QVF
Please refer to this thread:
YTD, MTD issue
May be this?
RangeSum(Before(Sum(Value), 0, ColumnNo()))
But Sunny, that would only work if the order of the Period is maintained.
Well, It would work, but Eddy, try to understand how to create time functions.
Why do you think that period will not be sorted? Not sure I understand your concern
I just want him to understand how to write time expressions
Thanks Omar, I will read this and try it out
Hi Sunny, I will also try your solution, let's see what the best
Both thanks for the quick answer !!
Hi Sunny, thanks for answer it works well
@ Omar , I will sure read your answer
Retrieving data ...