Forum Discussion
AdministratorMarguie
In the end I did it instead of with a measure, with a calculated column Monthly Goal = VAR Date = My Table[Date] RETURN CALCULATE(FIRSTNONBLANK(Goals[Goal],Goals[Goal] ), FILTER(Goals, (date > Goals[Date] & date <= EOMONTH(Goals[Date], 0))))
Advocate IIIHi Syndicate_Admin ,
it's a little difficult to say for sure without seeing your data and model, however, it sounds like you have a target for the month and you are trying to show this on a different granular level from what you have modelled.
Basically it all depends on how you have linked your targets to your calandar table. You could have linked the month to one specific date (e.g. the first or the last date of the month), since you're trying to see targets for one day. If so, that means that selecting a random (few) different day(s) for that month, without overlapping your linked target date, will give you a blank target, since there is no matching target for that specific day.
Another possibility is that you explicitely modelled the monthly target as such by linking to a month (which I would not recommend), but then there is no logic in selecting just a day (since that is on a much finer granular level than your targetdefinition). Selecting a month might also total the target times the number of days in that month, unles you are using for instance a min or max function.
My advice would be to recalculate your target to a granular level where you have a daily target available and link that to your calandar table.
Hopefully this makes sense.
Cheers