Forum Discussion
Post Patronweek over week but same day comparison
Post PatronThank you PattemManohar. One issue, I don't know how to solve. My case closure time is in the cases table 'duration_days'
Using your calc column-i used this below
CaseClosurePrevWeek = LOOKUPVALUE(VW_Cases[Duration_Days], 'Date'[Date],DATEADD('Date'[Date],-7,DAY))
I am getting this message
A table of multiple values was supplied where a single value was expected.
What am I doing wrong?
Thanks again!
Community ChampionI can see that you are using two different tables in the DAX expression. The DAX that I've provided is based on the assumption that both fields are in the same table.
- electrobrit
PattemManohar I like what you did though. My original data table I was showing what I wanted to be able to get to in the solution. Sorry about that.
They are 2 different tables. I have a date table and the case table and have related them.- PattemManoharelectrobrit Ok !! Then, on what field you have linked Case table and Date Table. Is that Date field ? then you must have Date Field in Case Table as well, so you can use that as part of your LOOKUPVALUE expression instead from Date Table. If that is not the case then please share more details about case table (ideally data model)
- electrobrit
PattemManohar thank you so much, sorry for being vague. Maybe this is why I'm having trouble with this calculation!
I have a date table and a case table with with a date (Date of Case Creation) which is how the tables are related
DateTable(Date) and CaseTable(CaseCreated)
So you are saying to just use that CaseCreated date?