move data from 1st cell into 2nd cell downwards

[siva3012]

Hi,

I  need to move the data from 1st cell into 2nd cell and leave the 1st cell empty.  

Can anyone guide me in doing this in PowerBI?  I have the screenshot which is required. 

[v-frfei-msft · Accepted solution]

Hi @siva3012 ,

To create a calculated column as below.

Column = 
VAR d =
    CALCULATE (
        MAX ( 'Table'[Local date Time] ),
        FILTER (
            'Table',
            'Table'[Local date Time] < EARLIER ( 'Table'[Local date Time] )
        )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[Local date Time] = d )
    )

For more details, please check the pbix as attached.

[Anonymous]

Hi Siva3012,

I've seen a few ways to calculate this. I find that the best way to calculate is creating a calculated column using the DAX formula below:

PrevValue = CALCULATE(MAX('TableName'[Value]), ALL('TableName'), 'TableName'[Local DateTime]<EARLIER('TableName'[Local DateTime]))

Here is an example that I created:

Hope this helps!

[siva3012]

@Anonymous  : Thanks your reply. I have applied the Dax code, but i am not getting the required output. In some places the value is not the same. I have highlighted data & have herwith attcahed in this screenshot. Can you please have a look at this