How can we fix Hardcoding in Visualisation??

[#1]

if(GetSelectedCount([Month])=0 and GetSelectedCount([Fiscal Year])=0,

num(sum({<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, month_end_metric_date_key={'20161031'}>}forecast),'#,##0'), The set analysis should be when the month_end_date_key = month_end_metric_date_key

num(sum({<calendar_year_month =  {'$(=Max(calendar_year_month))'}>}forecast),'#,##0')

)

[#2]

I am not sure if my understanding is correct?  When you say the date you need is 20161031 does it mean you are looking for the current month end date

[#3]

Yes True ..Current Month

[#4]

Ca you please try the below

Let varMaxDate = Date(MonthEnd(today()),'YYYYMMDD');

[mohitd910]

You Can use monthStart  , Month End Function