previous row value
3 Topics
Use previous row in current column calculation
Hello, trying to create a calculated column using data from the previous row. See example below for situation which has been calculated in excel for Indexation Factor. Indexation factor formula = B2*(1+A3) Within excel row B1 is manually set to 1 and the fields below are using the calculation above. Can this be replicated using a calculated column within PowerBI? Thanks in advance. (A) Selected Index (B) Indexation Factor 1 0.029683 1.029683334 0.004578 1.03439749 0.049629 1.08573384 0.047982 1.137829244 0.030898 1.172985656 0.028848 1.206823699 0.019598 1.230475107 0.010779 1.24373867 0.021425 1.270385647 0.037423 1.31792673 0.030566 1.358210528 0.025874 1.393353256 0.012128 1.410252314 0.057762 1.491711364 0.123262 1.675582498 0.043063 1.747738101Solved905Views0likes3Comments
Create date difference value column ?
Hello, I want to create a column like created column( current date - last date by country) in power bi. I have country/Region, date and death column. How do I create created column? Country/Region Date Deaths Created column Brazil 24-Apr-21 389,492 3,076 Brazil 23-Apr-21 386,416 2,914 Brazil 22-Apr-21 383,502 2,027 Brazil 21-Apr-21 381,475 3,472 Brazil 20-Apr-21 378,003 0 Argentina 24-Apr-21 432,312 90 Argentina 23-Apr-21 432,222 679 Argentina 22-Apr-21 431,543 309 Argentina 21-Apr-21 431,234 1,000 Argentina 20-Apr-21 430,234 0 thanks in advanceSolved1.6KViews0likes7CommentsDAX - Return Immediate Previous row value based on existing Rank
Hello there, I need a calculated column "Result" to be filled up with the immediate previous row value as shown below. Any suggestions please? PS: Do not want this to be a measure value, so may be this could be returned as a table output which can act like a temporary table. There are additional calculations lined up on top of this output. ID Date Rank Result ( Immediate Previous Date based on Rank for each ID) 1 01/01/2021 2 1 02/01/2021 1 01/01/2021 2 01/01/2021 3 2 03/01/2021 2 01/01/2021 2 05/01/2021 1 03/01/2021 Thanks, PravallikaSolved1.7KViews0likes1Comment