still SUM data which is out of the date filtered

[christianfcbmx]

Hi Dear Community,

Hi Community, I ve been bulding a dasboard but I ve had some issues and I d like you guys to help me out.

Im working with a Gauge Visual Object

What can I do to make this formula not include the budget of today... in the picture it shows the budget untill today but I need to sum to tha day before... (NOT CONSIDER TODAY) I tried a report level filter but it doesnt work.

Thanks in advance

BUDGET (Not include today) = SUMX('PACE DIA ((2))';'PACE DIA ((2))'[BUDIA])

[Greg_Deckler · Accepted solution]

Perhaps something like:

BUDGET (Not include today) = SUMX(FILTER('PACE DIA ((2))','PACE DIA ((2))'[Date]<TODAY());'PACE DIA ((2))'[BUDIA])

Assumes you have a [Date] column in your table.