I have a calculated column lets name as sales,
I want to pick the Max value for the Month end dates. Need to find which month end date has highest value and month name.
to have the sum of the values,
first add tis expression in your load
if(date(TRANSACTION_DATE)=date(MonthEnd(TRANSACTION_DATE)),1,0) as LastDayofMonth,
it will determine if the date if ths last day of the month
then in a text box, use :