cancel
Showing results for
Did you mean:
Helper II

## 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.

1 ACCEPTED SOLUTION
Community Support

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
3 REPLIES 3
Community Support

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

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!
Helper II

@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

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors