This content has been marked as final. Show 5 replies
I am using below functions to fetch current year and current month less one month but I am getting data for all years.
Although month is as expected by me.
let vCurrentMonthYear = '=year(addmonths(max(BillDate),1))';
let vPriorMonth = '=month(addmonths(max(BillDate),-1))';
Thanks and Regards,