Banging my head on how to filter my measure by month.
All my attempted expressions below end up in either "0" or sum up the entire set of records regardless of month.
Hoping someone can point out what I am missing ?
Thaks
// Creation of Variable LET vToday = Today(); LET vFirstDayOfCurrentMonth = MonthStart(vToday); LET vFirstDayOfLastMonth = AddMonths(vFirstDayOfCurrentMonth, -1); TempDate: LOAD Date('$(vFirstDayOfLastMonth)', 'YYYY-MM-DD') AS MostRecentCompleteMonth AUTOGENERATE 1; LET vMostRecentCompleteMonth = Peek('MostRecentCompleteMonth', 0, 'TempDate');
// Loading of Data SQL select DATE_TRUNC('day', cur_bill_billing_period_start_date) AS cur_bill_billing_period_start_date,
Load Date(cur_bill_billing_period_start_date, 'YYYY-MM-DD') AS cur_bill_billing_period_start_date
// Implement Chart Expressions
// This 'if' implementation works Sum(if(cur_bill_billing_period_start_date='2025-02-01',cur_line_item_unblended_cost,0))
// All these set analysis expressions fail - they sum all records (I think) sum( {$<cur_bill_billing_period_start_date={"=$(=Date(vMostRecentCompleteMonth,'YYYY-MM-DD'))"}>} cur_line_item_unblended_cost ) sum( {$<cur_bill_billing_period_start_date={"=$(=Date(vMostRecentCompleteMonth))"}>} cur_line_item_unblended_cost ) sum( {$<cur_bill_billing_period_start_date={"=$(=vMostRecentCompleteMonth)"}>} cur_line_item_unblended_cost ) sum( {$<cur_bill_billing_period_start_date={"=vMostRecentCompleteMonth"}>} cur_line_item_unblended_cost )
