The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.