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.

     

3 Replies

  • 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 

       

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    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.