Forum Discussion

frankegg's avatar
frankegg
New Member
3 years ago
Solved

Creating a new table with rows containing substring in a column

Hi   I am very new to PowerBI queries, and hope someone can push me in the right direction 🙂   I have a table as shown below, named RoomTable. I will use this to create a similar table co...
  • FreemanZ's avatar
    FreemanZ
    3 years ago
    Try to create a measure with the code below, then you shall be able to create your expected table visual with this measure:
    Meetingrooms :=
    CALCULATE(
         SUM('RoomTable'[Capacity]),
         FILTER (
             'RoomTable'
             CONTAINS (
                'RoomTable', 
                'RoomTable'[Room], 
                "Meeting"
              )
          )
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago
Try to create a measure with the code below, then you shall be able to create your expected table visual with this measure:
Meetingrooms :=
CALCULATE(
     SUM('RoomTable'[Capacity]),
     FILTER (
         'RoomTable'
         CONTAINS (
            'RoomTable', 
            'RoomTable'[Room], 
            "Meeting"
          )
      )
)