Set analysis with Max(Month)

[helen_pip]

Hello

I am using a master calender with my entire dataset, but want to show just the max(MonthYear) for just one particulare data set

I have tried a variation using set analysis, but have not quite got the code right yet, could someone kindly help me with the correct code

  {<data_source={'18_Wks_Admitted'}>}Max(MonthYear),'MMM YYYY')

Kind Regards

Helen

[helen_pip · Accepted solution]

Hello

Problem solved

=

Max({<data_source={'18_Weeks_Admitted'}>}MonthYear)

[#3]

Like this

=Sum({<MonthYear={$(=Max(MonthYear))}>}Sales)

Hope it helps you..!