Need to show data based on round column.

[Anshenterprices]

 

Hello ,

I have data in matrix  , there I am showing last 12 month average of cost column  , relate to round Column from other table.

Table 1 - I have main filed like date , cost 

Table 2 - date , rating column , round column.

Below is data which  is correct but only I need to remove date from below table that's the requirment.

Date.      Round.      Rating  last 12 month average 

1/1/2020.     19.         2.5.        100 

2/1/2020.      19.         3.           200

3//1/2020.                                 300

7/1/2020.       20.         4.           400

8/1/2020.       20.          8.           500

12/1/2020 

1/1/2021.        21.         8.            700

2/1/2021.        21.         6.             800

Now as above table I want only round column , rating column and cost 

Whne I select year in filters

...like 2021 my round is 21 only and rating average is 7 and last 12 month average is 428. Same for other years ..

I want round Column relate to cost column of 1 st table.  

Please help me to solve this .

[v-yiruan-msft]

Hi @Anshenterprices ,

Could you please share some original data in Table 1 and Table 2 and your expected result with backend logic and specific examples in order to provide you a suitable solution? Did you want to get the sum of distinct Round value? If yes, you can refer the solution in the following links to get it.

Sum of values based on distinct values in other column

SUM of distinct values

Sum distinct values for first occurance in Power BI

Best Regards