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.
Hi,
When a a query is refernced it brings the whole query. I was wondering if it possible at all to reference a query upto a certain step.
For example, suppose query "Q1" has 10 steps applied in it such as Step1, Step2, Step3...Step10.
I want to reference "Q1" in a way so that it bringsonly Step1-Step7.
Is there currently a way to do that?
Thank you in advance
that's only possible withing the query itself so e.g. step11 can reference step7 & step12 can reference step10 & step11
assuming what you describe is concerning multiple queries I would do the following
1) create Q1_1-7 covering steps 1 to 7
2) change Q1 to reference Q1_1-7 and then add steps 8-10
3) reference Q1_1-7 in the other query
@Stachuthanks for your reply. I am sorry I did not get it. Can you elaborate with an example please.
Yes, that's a really confusing reply!
say this is your Q1 query, and you want to reference step Custom3
Q1 - original syntax
let Source = 1, Custom1 = Source+1, Custom2 = Custom1+1, Custom3 = Custom2+1, Custom4 = Custom3+1, Custom5 = Custom4+1 in Custom5
I duplicate the query, and remove evything after Custom3, and name it
Q1_1-3
let Source = 1, Custom1 = Source+1, Custom2 = Custom1+1, Custom3 = Custom2+1 in Custom3
I change Q1 to reference the new query, tthis way if steps 1-3 change I only need to make it once
Q1 - new syntax
let Source = #"Q1_1-3", Custom4 = Source+1, Custom5 = Custom4+1 in Custom5
in the query that was supposed to reference till step3 I reference Q1_1-3 instead of Q1
does it make sense now?
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |