Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
misiek5510
Helper III
Helper III

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. 

 

 

misiek5510_1-1659104122003.png

 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

You could create the table like

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

View solution in original post

2 REPLIES 2
johnt75
Super User
Super User

You could create the table like

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

Thanks ! 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.