Forum Discussion

electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
7 years ago

week 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 ...
Need Help
electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
7 years ago

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. 

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago
electrobrit 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's avatar
    electrobrit
    Icon for Post Patron rankPost Patron
    7 years ago

    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?

    • PattemManohar's avatar
      PattemManohar
      Icon for Community Champion rankCommunity Champion
      7 years ago
      electrobrit Yes please, I don't see any reason why you can't use the Date field in Case Table which will solve your problem doing so. Give a try with that and lets see if you have any issues.
      • electrobrit's avatar
        electrobrit
        Icon for Post Patron rankPost Patron
        7 years ago

        PattemManohar


        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!!!