Associate
Hi,
I need to amend the following
(SELECT ( [Action date].[Calendar].[Date].&[20230413] : [Action date].[Calendar].[Date].&[20230401] )
so the actual data range is always "execution day minus 7 days : execution day".
I need to see last seven days worth of data on a day report runs basically.
I tried many solutions suggested by Google but can't make this thing work yet. Any help would be greatly appreciated.
Thank you
I need to amend the following
(SELECT ( [Action date].[Calendar].[Date].&[20230413] : [Action date].[Calendar].[Date].&[20230401] )
so the actual data range is always "execution day minus 7 days : execution day".
I need to see last seven days worth of data on a day report runs basically.
I tried many solutions suggested by Google but can't make this thing work yet. Any help would be greatly appreciated.
Thank you