Hello Everyone , I created a calculated column "Week Part " which will show the week number of the month . I used it in the filter so that the data can be filtered by weeks. As it is a calculated column, I am not able to do filter to latest data .My report is getting refreshed every week .Whenever it is getting refreshed , the report is not pointing to the latest data(new data that got refreshed) . How can I resolve this issue , so that whenever the report is refreshed , I can see that the report is pointed out to the latest data.
This is the formula I used to calculate week number .
DATEPART('week',[Created Dtm]) - DATEPART('week',DATETRUNC('month',[Created Dtm]))+1
create below calculated field and placed it in filter shelf and select true.. if you want to see latest week.
if it does not work i would like to see workbook with dummy data
Mark this answer as correct if it solves your problem.