Create week before calculation

Questions & Answers
1

Hello Everyone, I am new to easyBI.
I wrote a calculation for week before previous week-
[Time Resolved.Weekly].[Last week].PrevMember

where Last week is -
Aggregate({

  • [Time Resolved.Weekly].[Week].CurrentDateMember.PrevMember*
    })

Week before does not show the correct results. Can somebody please help me?

Failed to execute query. Error message:
Internal error: member [Time Resolved.Weekly].[Last week] not found among its siblings

2

Hi Ritika,
You could try using DateMembersBetween function with relative, for example:

Aggregate(
[Time Resolved.Weekly].[Week].DateMembersBetween('2 weeks ago', '1 week ago')
)

I hope this helps.

Kindly,
Ilze