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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello
I'm trying to pull out the following calculation that I show below with DAX,
the "Valor_3" is the "Valor_2" of the previous column + "Value1" of the back column and so on. ("Value1" and "Value2 are measures") :
"value1","value2" are measures.
I don't know if anyone can help me.
Thanks a lot.
@Syndicate_Admin , A new measure
sum(Table[valor2]) + calculate(sum(Table[valor1]) , filter( allselected(Table), [indice] <= max([indice]) && [valor2] =0))
a New column
sum(Table[valor2]) + calculate(sum(Table[valor1]) , filter( (Table), [indice] <= earlier([indice]) && [valor2] =0))
Thank you, for the quick response, but it is not valid for me.
Since it is a display table, and "value1","value2" are measures, not calculated columns.