Forum Discussion

Drue's avatar
Drue
Frequent Visitor
5 years ago
Solved

Calculated column with values from an unrelated table

Hey folks! I am running into an issue that I can't solve, and can't find an answer to in the forums.   First and foremost, here is my file.   I have a table Budget and a table GL that are not rel...
Need Help
  • Drue's avatar
    Drue
    5 years ago

    I was actually able to finally solve my own problem, adding a calculated column to the data. Here is the forumla that worked:

     

    New Budget =
    IF(
    Budget[Account]="36",
    (CALCULATE(SUM(GL[Actual]),
    FILTER(ALL(GL), MONTH(Budget[Date])=MONTH(GL[Date]) && YEAR(Budget[Date])=YEAR(GL[Date]) && GL[Actual]>0))*0.03)+Budget[Budget],
    Budget[Budget]
    )
Drue's avatar
Drue
Frequent Visitor
5 years ago

I was actually able to finally solve my own problem, adding a calculated column to the data. Here is the forumla that worked:

 

New Budget =
IF(
Budget[Account]="36",
(CALCULATE(SUM(GL[Actual]),
FILTER(ALL(GL), MONTH(Budget[Date])=MONTH(GL[Date]) && YEAR(Budget[Date])=YEAR(GL[Date]) && GL[Actual]>0))*0.03)+Budget[Budget],
Budget[Budget]
)