cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Add a new column based on exiting column with disconnected tables

Can some one in the scenario mentioned below? I am mentioning a sample dataset, there are two tables where relationship doesn't exist and not even going to exist in the actual model. As per the requirement, if the user would select Primary from the slicer(Table 2 -- Column Name: Selector), on the Summary Table Column: PrimaryMarket should be displayed or if the User would select Secondary from slicer, the Summary table should show Column:SecondaryMarket along woth other columns.

As per my understanding, we would have to create a Caultaed field in Table1 which will be used in the Sumarry table. However while cretae a Calculated field, it is not working and only giving me false result.

DataModel.PNG

6 REPLIES 6
Community Support
Community Support

@thePowerBIGuy,

 

You may select Unpivot Columns in the Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

The original dataset is as such that it can't be un-pivoted. Any other work around?

@thePowerBIGuy,

 

As far as I know, there is no more elegant way.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @thePowerBIGuy

 

What do you mean by "The original dataset is as such that it can't be un-pivoted"?






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

@danextian: We cant make changes in the structure of the master dataset in the original Model(based on that I have created a sample one mentioned in the problem statement)

@thePowerBIGuy,

 

How about just referencing the query and unpivot it instead of the original one?






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors