Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement where I have a table which shows me 12 months of data if I select any month
So if I select Mar-2018 table shows me
Jan, Feb+Jan, Mar+Feb+Jan, Apr+Mar+Feb+Jan and so on... for 12 months and dimension here is YearMonth.
This data is based on actuals and budget
So if I select Mar
The data for months less than or equal to Mar should have label as Actual
and Date from Apr to Dec should have label as Budget
I tried quite a few expressions but doesn't seem to get it.
This label is dynamic... I can select any month here but selected and previous months are always Actuals in label, months falling after current selection are labeled as budget.
any help is appreciated.
Try this out
=Aggr(Only({1} YearMonth) & Chr(13) & If(GetSelectedCount(Month) = 1, If(Only({1} [Year Month Num]) <= Max(TOTAL [Year Month Num]), 'Actual', 'Budget'), If(Only({1} [Year Month Num]) = [Year Month Num], 'Actual', 'Budget')), YearMonth)