Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I need some help.
I have to create a sum acumulating the diference between 3 measures.
These measures are from diferent files.
The rule is: Evolução = PV - FAT - CART in january.
In February is the some, but need to add the value of january.
Incorrect
Would be
Thanks for the help.
I'm confused with this part of the measure ('Date'),'Date'[date].
I use the dCalendario[Data].[Mês] how month.
The return of dCalendario[Data].[Mês] are Janeiro, Fevereiro, etc...
@MatSantos , Assume these are measures
CALCULATE([PV] - [FAT] - [CART] ,filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
example
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!