Forum Discussion
Solved
Distinct Values based on report date
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.
You could create the table like
New Table = SUMMARIZE( 'Old Table', 'Old Table'[Date], 'Old Table'[Site])
2 Replies
You could create the table like
New Table = SUMMARIZE( 'Old Table', 'Old Table'[Date], 'Old Table'[Site])Thanks !
