Forum Discussion
Helper Ican i make One table base on another Table
I want to make a table B that take the values from table A's row value. But I am not not sure when table A's dataset is swaped, let say I add 1 more year data to Table A, can table B automatically generate the data from table A?
Hi henry24007
You can create table B in PQ (probably best) or with a calcualted table in DAX
Both tables will be updated when the report is refreshed (either on the desktop or in the service)
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Hi henry24007 ,
I have connected to an excel file in Power BI Desktop and then duplicate it as Table2.
In my test, the two tables will be updated after I click on "Refresh All" in PQ or ”Refresh“ in PBI:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- AlB
Community Champion
Hi henry24007
You can create table B in PQ (probably best) or with a calcualted table in DAX
Both tables will be updated when the report is refreshed (either on the desktop or in the service)
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
henry24007so I just duplicate the table A to create table B right?
Hi henry24007 ,
I have connected to an excel file in Power BI Desktop and then duplicate it as Table2.
In my test, the two tables will be updated after I click on "Refresh All" in PQ or ”Refresh“ in PBI:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- AlB
What do you mean? Is B not a modified version of A?
Why would you need an exact copy of table A?
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
- henry24007
B is a modified version of A, I am thinking using the duplicate A to make operation create B, can B be updated when it is the duplicated version of A? is it a silly method?