Forum Discussion
Newbie: RELATEDTABLE question.
What formula would I use to move the "Sales" form the fSales_Data table over to the fOutage_Data table as a calculated column? The sales data is plant number and date specific and the outage data is also plant number and date specific.
Example: 1/1/17 for plant 1001 has sales of 10 units in the sales data table. In the Outage_Data table, I want the 1/1/17 outage data record for plant 1001 to show a calculated column that shows the sales as 10 units that is pulled in from the Sales__Data table.
1 Reply
- Greg_Deckler
Community Champion
Sample data would help, but it should be along the lines of:
Column = CALCULATE(MAX(fSales_Data[Gallons]),RELATEDTABLE(fSales_Data))
Something along those lines. The inherent context of the row in fOutage_Data should essentially reduce the relatedtable to a single row, the corresponding row in fSales_Data. Otherwise, you might have to wrap your RELATEDTABLE in a FILTER function.
