Forum Discussion
Populate value for every date using a measure, not a column
Super UserThe 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.
Unfoturantely this also does not work - on a chart this measure still gives me Budget value only for 1st of the month as a one blue point, instead of a blue line with the same value for every day:
BUD Value = MAX(Budget[Budget Value])- johnt75
Try
BUD Value = CALCULATE ( MAX ( 'Budget table'[BUD Value] ), STARTOFMONTH ( 'Date'[Date] ) )