I am struggling with incorporating a YTD based on Period selection to work for my Firstsortedvalue expression.
The expression i am using to calculate amount based on max Allocated date is attached.
the date driver is GL date, i have made a Period(YYYYMM) from GL date as a measure. I now need to show YTD based on Period selected and not only that specific Period selection.