Forum Discussion

siva3012's avatar
siva3012
Icon for Helper II rankHelper II
6 years ago
Solved

move data from 1st cell into 2nd cell downwards

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.     
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
siva3012
Icon for Helper II rankHelper II
6 years ago

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