User Profile
WaXpEd
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Re: Cumulative Total with Reset on Negative amounts
Hi Anonymous, Thanks for taking the time to answer me. As the picture below : The file contain a lot of UserIDs The balance of credits is already calculated Current Result : what i've done so far, without the reset Desired Result : We need to know what credits are added/removed based on the balance. We have a glitch in our UI that not remove credits if the balance go <0. Based on this we do not take the values when the balance go under 0. But once the client buy credits, we need to reset the balance with the amount of credits purchased without considering the negative balance on the previous lines. Don't know how to up the pbix, but here is a picture : Hope this helps, If not, will try my best but... Thanks anyway for yout time, WaX.Cumulative Total with Reset on Negative amounts
Hi the PB community, I think one picture will summarize better than words. I try to have the display of our UI based on a credits adding / removing. (but sometimes there is some bugs). Once the cumulative count is at 0 or negative, the formula should display 0, otherwise, the amount of credits. But once we get credits back, I cant reset the count, it will sum the last values. I have the overall formula with EARLIER but can't find a way to make him understand to take only credits after the last adding without negative values before. In EXCEL, formulas is : =IF(SUMIFS($W$1:W3;$C$1:C3;C4)+V4>0;V4;0) Thanks in advance to any helper 🙂Columna DAX & SUMIFS con el trimestre anterior
Hola a todos Estoy tratando desde hace 4 horas de lograr esta fórmula. Sin ningún éxito... Estoy tratando con la función anterior de recuperar el importe total en un trimestre de un trimestre anterior en la columna. Índice Cuarto Proyecto Proyecto Combo Combo de índice Valor Valor anterior 1 Q2 15666666 Q215666666 1 10 0 2 Q2 15666666 Q215666666 1 20 0 3 Q2 15666666 Q215666666 1 30 0 4 Q3 15666666 Q215666666 4 40 60 5 Q3 15666666 Q215666666 4 50 0 6 Q3 15666666 Q215666666 4 60 0 En Excel, he realizado SUMIFS en la columna "Valor anterior" con el argumento "Q2", pero esto no es posible en PowerBI, ya que se hace referencia a la fila en "Q3". No puedo conectar un número específico bajo la función anterior para tomar el valor anterior "Combo de índice", ya que puedo tener varios valores en cada trimestre para cada proyecto. Gracias de antemano, creo que he explorado toda la combinación de antes de allí. Cera.
