live report no date change

[charlie298]

I want to have a live report which is updated on a schedule but users do not need to click a slicer for the most recent week. I cannot find awa. ideas. i know i am going to kick myself.

[samdthompson · Accepted solution]

@charlie298, welcome abaord.

I have done this with a caculated column. There might be a better way but it seems to work for me. I just do a column with current date= max(date) with gives me the highest (most recent date) this seems to work. I just refer to this in my measures.