Forum Discussion

misiek5510's avatar
misiek5510
Icon for Helper III rankHelper III
4 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    4 years ago

    You could create the table like

    New Table = SUMMARIZE( 'Old Table', 'Old Table'[Date], 'Old Table'[Site])
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could create the table like

New Table = SUMMARIZE( 'Old Table', 'Old Table'[Date], 'Old Table'[Site])
misiek5510's avatar
misiek5510
Icon for Helper III rankHelper III
4 years ago

Thanks !