Forum Discussion
Solved
Remove rows based on another table
Hello all. I am trying to optimize a little bit my report. I have two main objects which are related. The main one it is called Ticket, and it has an ID and Status The second one are tasks, wit...
Chavas , In most of the connection, you have an advance option, you can give a query there. so add this query using new connection route
Yay!
That is a solution!
But the problem is that I have to hardcode the status in the query. In a future, If I want to change it, I will need to redo the query or minding that I have hardcoded somewhere.
Is there any other fancy/more elegant option?
(I am quite new to PowerBI, so your solution might be the way)
Copied. From now I will perform the short path as far as the clock is bitting me.
Thanks for the assistance!