l

No wonder it does not work... Please try to first learn about how to work properly with time-intelligence functions (www.sqlbi.com could help). DATESINPERIOD does not work on any table that has a column of dates. Also, measures should not really be tied to TODAY(). They should work with any date from a properly built Date table.

Best

Darek