Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys!
i have build the formula below that is working perfectly.
BTW i have to create another one where the SurgeryMonthYear should be the MonthYear minus 12 months. Anyone knows which is the right syntax?
Thanks!
=Sum({<SurgeryMonthYear={$(=concat(chr(39) & MonthYear & chr(39),',') )},MonthYear=,Day=,Year=,Month=,Quarter=>}[Surgical Procedures WI])
You can use AddYears() / AddMonths() function to get the date one year ago.
AddYears(MonthYear,-1)
use a Date() or MonthName() format to get the same format required by your SurgeryMonthYear, e.g.
MonthName(AddYears(MonthYear,-1))
Did you checked out the suggestion from this thread of yours?