How to get the latest result so far?

Questions & Answers
3

Hello @zane.baranovska

I had a similar question elsewhere (Last Record in a Time Period - #3 by Rutwij_Devashrayee) and this solution seems like it would be relevant to that question as well. When I use the above mentioned solution or something like below, I get a sum of the previous day and not the last record of the day. Any idea?

Tail(
  {[Time].[Day].CurrentDateMember.PrevMember,
  [Measures].[Coverage Percentage]},
  1
).Item(0)