Forum Discussion
Sum from Multiple Tables
amitchandak Yes, I have. As I said, I have various reference tables & calculated columns to make everything consistant on the outside. The only piece of that I haven't figured out is how to deal with date ranges vs. single dates. So on the visual pages, I have columns available for use that are pulling from the connected tables. So FR and France appear as Europe, and US & USA appear as North America, to use my earlier examples.
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.