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 re...
You could create the table like
New Table = SUMMARIZE( 'Old Table', 'Old Table'[Date], 'Old Table'[Site])
You could create the table like
New Table = SUMMARIZE( 'Old Table', 'Old Table'[Date], 'Old Table'[Site])Thanks !
