Forum Discussion
charlie298
10 years agoNew Member
live report no date change
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.
- 10 years ago
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.
samdthompson
Memorable Member
10 years agocharlie298, 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.