Forum Discussion
Sum from Multiple Tables
datadude2020 , Thrid one is simple, You can join on start or end date. And you will see data at month level. Second data seems to be at year level. Have year a number or same as FY in calendar. One option is, that do not join and always have a measure that take date and find its year
Like
Measure= Var _max = year(maxx(allselected(Date),Date[Date]))
return
calculate(sum(Report2[Value]), Report2[Value] =_max)
Another way is to move the data year start date.
Date = Date([Year],1,1)
But data will not be Shown in any other month.
amitchandak I don't think you're understanding my goal. My main problem here is getting a composite sum for account, date, and location.
As I said before, I can get two of the three to work. I can get a composite sum based on account and date or account and location, or by location and date. I need all three together. I already have tables to convert any non-standard data. The example data I posted is raw data - before my standardizations. My problem is combining them after standardization.