Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |