Forum Discussion
dax
Hi,
I hvae two tables: in the first one i have the order detail: one column with the order id, one with the property id an one with the price per order
in the second table i have one column with the property id and the property name
what i need is to create an extra column in the second table that sums the total cost of the orther for each property id
¿could you help with the function?
2 Replies
- Greg_Deckler
Community Champion
americahe Maybe:
Column = VAR __ID = [Property ID] VAR __Table = FILTER('First Table',[Property ID] = __ID) VAR __Result = SUMX(__Table, [Price Per Order]) RETURN __Result
