Help with creating a table

Hi visheshvats1 ,

Based on my testing, it is impossible to create a disconnected table result with another table calculated measure.

1.Create the simple table.

2.Create the new table.

Table 2 = CALENDAR(DATE(2024,1,1), DATE(2024,12,31))

3.Create the new year and month column.

Year = YEAR('Table 2'[Date])

Month = MONTH('Table 2'[Date])

4.Create the measure to calculate amount. Drag the measure into the Table.

Measure = CALCULATE(SUM('Table'[Amount usd]), ALLEXCEPT('Table', 'Table'[Year], 'Table'[Month]), FILTER('Table', YEAR('Table'[Date])= 2024))

5.Create a new values column. Drag the column into the disconnect table visual. The result is shown below.

valuescol = [Measure]

6.If create a connection between two tables, the result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.