I am struggling with some date ranges in my dashboard. Trying to get values for a 12-month period starting with the previous month. When I use the expression:
Sum({<[calendar.full_date] = {">9/30/2022 <10/1/2023"}>} (([Amount2]/100))) I get the values I am looking for, but when I use:
Sum({<[calendar.full_date] = {">Date(MonthEnd(AddMonths(Today(), -13))) <Date(MonthStart(Today()))"}>(([Amount2]/100))) the output is just 0.
Would appreciate any insight. I have already checked and changed the data type in my data load for calendar.full_date field by using:
Date(calendar.full_date) AS calendar.full_date
