cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

merge query colums selection based on slicer selection

Hi,

 

I have a situation like this.

I have two table.

 

table 1: column headers as

Order#   Date   Spec1   Spec2  Spec3  default1   default2 default3....

 

table 2: column headers as

ConfigID   Spec1   Spec2  Spec3  default1   default2 default3....

 

I merged two tables in quers selecting  - Spec1   Spec2  Spec3  default1   default2 default3.... columns in both the table to match all selected column entries in two tables and returning a configID for a order#.

 

Now the case is I need a slicer to select spec 1/2/3 or combinations of them to match during merge queries. The default1/2/3 are default during merges.

 

for example, if I select spec1 & spec3 in a slicer say, the merge should happen based on matching the values in spec1, spec3, default1   default2 default3....

 

Any small help would be appreciated.

 

Thanks in advance.

1 REPLY 1
Highlighted
Community Support
Community Support

Re: merge query colums selection based on slicer selection

Hi @vissvess ,

 

As I know we cannot create a dynamic calculated table in power bi. Maybe we can work it out by some other ways to work around. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors