Forum Discussion

ruhor's avatar
ruhor
Frequent Visitor
10 years ago
Solved

Filling in Calculated Colmn Values if an Entry Exists in Another Table

I have two DB tables which I imported into Power BI. One is a table of rental properties named "property" and the other is a table of metered utilities named utilityprops. I added a new column to the...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Make sure that utilityprops is related to properties (many to one) and then use this for your metered column:

    metered = IF(COUNTX(RELATEDTABLE(utilityprops),'utilityprops'[propid])>0,1,0)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Make sure that utilityprops is related to properties (many to one) and then use this for your metered column:

metered = IF(COUNTX(RELATEDTABLE(utilityprops),'utilityprops'[propid])>0,1,0)
  • ruhor's avatar
    ruhor
    Frequent Visitor
    10 years ago

    Works perfect, thanks.