How to create new table

[Anonymous]

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?

[v-shex-msft]

HI @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

[amitchandak · Accepted 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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[az38]

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

LinkedIn