Forum Discussion
Calculated Column with previous report index
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
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
3 Replies
ThiagoDuarte , Create a new column like
new column =
var _1 =[rpc_id]
return
maxx(filter(Table, [rpc_next_report_id] =_1),[rpc_id])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
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.
