Current Week "created date vs resolved date" reports

Rohith_5dauaf

I am planning to get "created date vs resolved date" EazyBI reports for the current week, where I have taken TIME in ROWs with calculated measures as weekly 

Aggregate(
Filter(
[Time.Weekly].[Week].Members,
DateBetween([Time.Weekly].[Week].CurrentMember.StartDate,'1 weeks ago','today')
))

Supposed to get only values of the current week(i.e, last 7days from today). But in my reports, we are getting a few extra values. 
sharing my screenshot that might help you.  In second Image RED highlighted shouldn't appear.

Thanks,
R.K

Ilze Leite-Apine - eazyBI

Hi, Rohith,

You are already there: you may try modifying the Time Weekly calculated member and aggregate Day level members instead of Week level members as well as use "7 days" instead of one week ago:

Aggregate(
Filter(
[Time.Weekly].[Day].Members,
DateBetween([Time.Weekly].[Day].CurrentMember.StartDate,'7 days ago','today')
))

 

Ilze, eazyBI Customer Support Consultant

support@eazybi.com