Forum Discussion
electrobrit
Post Patron
Post Patronweek over week but same day comparison
I have 2 tables: Date and Cases which is daily detail of the cases coming in daily. I would like a simple line chart to show weekly comparison with the past 7 days and a line comparing the previous ...
electrobritPost Patron
Post Patron
CaseClosurePrevWeek=LOOKUPVALUE(VW_Cases[Duration_Days],VW_Cases[CaseCreatedOn],DATEADD(VW_Cases[CaseCreatedOn],-7,DAY))
getting the same error. "A table of multiple values was supplied where a single value was expected".
any thoughts and thanks, you've been helpful!!!
electrobritPost Patron
Post Patronam I missing something in DurationDays? this is how long a case is open.
I can't figure out what to do.