Apply similar formula to all rows of a calculated colum

[powerbisach]

Hi ,

I have this requirement where i have one column from which i need to get the Diff_amount and %Change

The column Diff_amount and % change contains large rows, so i need to replicate the same formula for this column.

With excel i can easily perform a drag and drop operation. How this can be performed in powerbi adding a calculated columns.

[powerbisach]

Hi,

Unfortunately your solution did not worked. Any other idea?

[v-sihou-msft · Accepted solution]

@powerbisach

In Power BI, rows in table has no sequence internal. So if you want to handle some "previous/next" scenario on row level, you must create an index column in your table. You can do it in Query Editor. Then you can create your calculated column based on this index column easily.

Regards,

[TomMartens]

Hey, 

first create a calculated column using the LOOKUP() function

LOOKUPVALE('yourtable'[Amount], 'yourtable'[Year],'yourtable'[Year]-1) - 'yourtable'[Amount] for DiffColumn (or the other way round)

then, just create a calculated column using both columns

Hope this helps

Regards