For the below table, I intend to use an KPI measure to show MTD Sales. But the MTD Sales should show the summary of values until last week. For getting the last week data, I use the expression =if(getselectedcount(Date)=0,num(WeekStart(today()-7)),Date). But I want to use this expression to get the MTD Sales on the KPI measure for last week.
Could you please help me with an expression to get the sum of MTD Sales for last week for the KPI measure