Forum Discussion
Syncing Dates Across Multiple Tables
You could wrap your [Project ID] columns in a MAX potentially. Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sounds like you need to do something like:
Measure = CALCULATE(SUM(Table2[Column]),FILTER(ALL(Table2),Table2[Date]<=MAX(Table1[Date])))
Greg, definitely on the right track. However, I need to also have a connection to each particular project. I tried adding another FILTER(ALL(Table2, Table2[ProjectID = Table1[ProjectID)), but that returns an error. It's looking for some type of aggregation.
Thanks again.
You could wrap your [Project ID] columns in a MAX potentially. Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Greg,
I am still having issues. I have a link to OneDrive where I have my PBIX file. https://adolfsonpeterson-my.sharepoint.com/:u:/g/personal/tlenzmeier_a-p_com/EVFfBpTdhGdMr8cs76X64hsBMM0KrZ74wLRhh9MppiTivQ?e=Ox9BVP
To summarize, for each projection date in the projection history table, I need to amount to date costs from the project transactions table.
Thanks, in advance!