Solved: live report no date change

charlie298 · ‎06-08-2016

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 · ‎06-08-2016

@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.

// if this is a solution please mark as such. Kudos always appreciated.

View solution in original post

samdthompson · ‎06-08-2016

@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.

// if this is a solution please mark as such. Kudos always appreciated.