Forum Discussion
How to create new table
I would like challenge to understand how to create new Table Facility, which is based on several tables data.
Let say I first duplicate MaintenanceCard table and rename as Facility. How do I get "Facility" column, which behind of relationship of MaintenanceId->MachineId->Facility?
Refer
https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
3 Replies
Hi Anonymous
try to create a calculated table
Facility Table = SELECTCOLUMNS(Machine;"Facility";Machine[Facility];"MaintenanceDescription";RELATED(MaintenanceCard[MaintenanceDescription]);"EndDay";RELATED(MaintenanceCard[EndDay]))be sure you have relationships
do not hesitate to give a kudo to useful posts and mark solutions as solution
Refer
https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601HI Anonymous ,
I not so clear for your operations, can you please explain more about merge logic and filter conditions?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng1
