Forum Discussion
Return Audit Reporting
We are currently in week 52. I am trying to access return audit report data for my store (2749). The latest information available is week 49. Other stores that I have spoken with have access to week 50. The page shows that it last updated on 1/23/23. How many weeks behind is the reporting designed to run? I have tried in the overview, detail, and drilldown. All three only show up through week 49. Any assistance you can provide would be greatly appreciated.
1 Reply
- amitchandakSuper User
JHBURLE , Not very clear,
We usually add a column to the date table
if( [Year Week] = Max(fact[Year week]), "Max Week", [Year Week] &"")
and save your page for max week
Year week means format YYYYMM
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA