Calculated Column with previous report index

[ThiagoDuarte]

Hello there,

I need a help with a calculated column that returns the previous report index:

In this case the main_field represents a part that's going through processes. As it goes from one stage to another a new report is automatically generated using the id on rpc_id_nextreport (All this happens automatically and I have no access to modelling the SQL base).

Now, I need a calculated column that gives me the previous report index. I'm looking for this result:

rpc_id_previousreport = calculated column

Thanks

[v-janeyg-msft]

Hi, @ThiagoDuarte 

You can easily create a calculated column to show the result.

Like this:

Column = LOOKUPVALUE('Table'[id],'Table'[id_nextreport],'Table'[id])

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ThiagoDuarte , Create a new column like

new column =
var _1 =[rpc_id]
return
maxx(filter(Table, [rpc_next_report_id] =_1),[rpc_id])

[ThiagoDuarte · Accepted solution]

Thanks amitchandak but i worked my way around it.

I created a calculated table using summarize function to get the report id and the previous id in the same row then i created a relationship between the two tables.

It worked for me and it gives me such a faster response.

But thanks again