Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |