Distinct Values based on report date

[misiek5510]

Hi,

I'm trying to get a result as shown on the basic example below. I need to create a table or just a column to show distinct values within a given month. If site appears more then once withn reporting date it should show it only once. 

[johnt75 · Accepted solution]

You could create the table like

New Table = SUMMARIZE( 'Old Table', 'Old Table'[Date], 'Old Table'[Site])

[misiek5510]

Thanks !