Forum Discussion

charlie298's avatar
charlie298
New Member
10 years ago
Solved

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.
  • samdthompson's avatar
    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.