I'm trying to create a calculated column and this formula worked before but doesnt now. Maybe it was an update or a wrong formula from the beginning.
I want to pull in the location of the budget for a given [Tech]. These locations can change over different months and I want the fact table to track along with the Budget table. These two tables are fact tables and only have a many to many relationship connection with the Dates table. Can someone help with this code?
I am getting an error "A Table of multiple values was supplied where a singe value was expected."