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 ...
PattemManohar
Community Champion
Community Championelectrobrit I believe the "Date" field and "Duration_Days" in the sample data are in the same table. Is that not the case ? Please confirm.
I 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.
I 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.
electrobritPost Patron
Post PatronPattemManohar 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?- PattemManoharelectrobrit 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.