Forum Discussion
Using a field in a visual to filter a different field.
Hi, maryhillegass ;
You could duplicate three same table in power query.
Then create relationship about this three table,
The final show:
Of course you can also use your three tables:
Finished Batch 、Intermediate Batch、Raw Materials
Then set up the following relationship like I did.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, maryhillegass ;
You could duplicate three same table in power query.
Then create relationship about this three table,
The final show:
Of course you can also use your three tables:
Finished Batch 、Intermediate Batch、Raw Materials
Then set up the following relationship like I did.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yalanwu-msft Is there a way to do this without the duplicate tables?
The tables in my dataset would be fairly large and I wouldn't want to have to store them 3 times if it was not necessary. This would accomplish what I was originally asking.