Hi All
i have requirement where i need to display all the prior week in the value prompt from he current week.
week starts on saturday , so the current date is thrusday, then i need to show all the prior weel from previous week.
i was able to fetch the current week but unable to fetch the previous week.
lastperiods(14,item(filter([Labor].[Date].[Hierarchy - Fiscal Year].[Date],[Labor].[Date].[Hierarchy - Fiscal Year].[Date].[Current Date Flag]='y'),0))
can you please let me know how to go about it
Thank you,
Lalitha