Forum Discussion
Populate value for every date using a measure, not a column
johnt75 : Unfortunately I am getting below error:
A table of multiple values was supplied where a single value was expected.
I tried to put this measure on a Table only with Date as a column.
I am getting similar error whenever I am trying to create any measure that in fact should be a column.
Probably not the reason, but I will ask anyway: the Date column and Budget Value column are located in different tables - could that be the reason it doesn't work ?
johnt75Super User
The budget table has a date too, right? For the first of the month? That column is the one you need to use as the second parameter to LOOKUPVALUE
Budget table does not have Date column itself. Budget table is connected with Calendar table, which has Date column. However Budget Value and Date are connected with each other. I do not know by which key exactly, as this is built-in in sql cube directly, which I do not have access to, but I can filter Budget value by Date. Just physically/technically these columns are not in one table.
I was wondering whether this may be the reason the formula you provided is not working... ? 🤔- johnt75
If Date is filtering budget then you can probably use a simple MAX('Budget'[Budget value]) and rely on the date from the visual to filter it appropriately.