I have a dilemma in my Tables and Columns. We manage preventative work in an application and I'm working with that data. I notice that when the preventative work is tied to an "Asset", the "Location" column in the Asset Table is populated, however, if the preventative work is not tied to an "Asset", the "Location" column in the Asset Table is NOT populated, but IT IS populated in a "Location" column, from the Preventative Maintenance (PM) Table. Here is a visual representation of what I see:
|DIV.POOL.VEHC.01||STX65642||VEHICLE STATE REGISTRATION / INSPECTION - DIV - ANNUAL||VEHC19992||SHIROCKW||1||YEARS||3/18/2018 0:00|
|PS.SUN.TANK.01.LS.01||STX22701||BREAKOUT TANKS - OVERFILL PROTECTION - SUN - ANNUAL||LS20739||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN.TANK.02.LS.01||STX22702||BREAKOUT TANKS - OVERFILL PROTECTION - SUN - ANNUAL||LS20740||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN.PT.02||STX23211||OPSD INSP - ELECTRICAL - SUN - ANNUAL||PT66735||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN.UPS.01||STX68897||UPS ELECTRICAL INSP - SUN - ANNUAL||UPS28764||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN.HS.01||STX69913||STATION PROTECTIVE DEVICE - SUN - ANNUAL||HS19769||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN.PT.01||STX76853||OPSD INSP - ELECTRICAL - SUN - ANNUAL||PT25924||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN.PT.03||STX76854||OPSD INSP - ELECTRICAL - SUN - ANNUAL||PT25925||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN||STX78624||ANNUAL ELECTRICAL INSPECTION - SUNFIELD PUMP STATION||FONTESD||1||YEARS||3/17/2018 0:00|
|PS.SUN||STX79539||STX2086||LEVEL MEASUREMENT - SUN - ANNUAL||FONTESD||1||YEARS||3/17/2018 0:00|
|INJ.PNNB||STX78662||ANNUAL ELECTRICAL INSPECTION - PATTON NORTH BATTERY||OSORIOM||1||YEARS||3/16/2018 0:00|
I want to build a "cleaner" report...the end user doesn't understand how this works and essentially wants just "one location" value. What they would like to do is see the report and essentially show everything at "PS.SUN" and get a list of that information displayed. They don't really care if tied to an asset or not, it's all work at that "main site". How do I get this to work? Totally lost here; any help will be greatly appreciated.
Solved! Go to Solution.
Thanks; saw the video but cannot select both columns, they are in different tables and when I try and use Shift and/or Control with a Click Select, one of the selections defaults to the first column of the last table, so it merges a different column and not the one I want. Is there another way to select them?
I also went to each table and moved the column of Location to the beginning to see if that would make the selection easier but it didn't.
What it the relationship between both tables (Asset and Preventative Maintenance)
I think you can use Related Function.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.