Set Analysis Month, Week

[Anonymous]

Today
SUM({$<[Date Num]={$(=TODAY())}>}[ID Count])

 Yesterday
SUM({$<[Date Num]={$(=TODAY()-1)}>}[ID Count])

What will get me

• This week
• Last week
• This Month
• Last Month

[Kushal_Chawda · Accepted solution]

@Anonymous  try below

// This week
SUM({$<[Date Num]={">=$(=num(weekstart(max([Date Num]))))<=$(=num(weekend(max([Date Num]))))"}>}[ID Count])

// Last week
SUM({$<[Date Num]={">=$(=num(weekstart(max([Date Num]),-1)))<=$(=num(weekend(max([Date Num]),-1)))"}>}[ID Count])

// This month
SUM({$<[Date Num]={">=$(=num(monthstart(max([Date Num]))))<=$(=num(monthend(max([Date Num]))))"}>}[ID Count])

// Last month
SUM({$<[Date Num]={">=$(=num(monthstart(max([Date Num]),-1)))<=$(=num(monthend(max([Date Num]),-1)))"}>}[ID Count])