Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
Solved! Go to 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.
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.