IN POWER BI HOW TO FIND UNIQUE CUSTOMERS FOR A PARTICULAR MONTH WITH RESPECT TO DATE

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could add another date table without relationship as slicer.

date = SUMMARIZE( SUMMARIZE('Table',[date],"month",EOMONTH([date],0)),[month])

then add a flag measure to filter it.

flag = 
IF (
    MAX ( 'Table'[value] )
        IN SUMMARIZE ( FILTER ( 'Table', [date] <= MAX ( 'date'[month] ) ), [value] )
            && CALCULATE (
                COUNT ( [value] ),
                FILTER (
                    ALL ( 'Table' ),
                    [value] = MAX ( [value] )
                        && [date] <= MAX ( 'date'[month] )
                )
            ) = 1,
    1
)

set the filter.

The final show as follow:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Thank you so much!

[Shishir22]

Hello @Anonymous ,

Give relationship between two tables on date column.

Create measure as DistinctCount(Selphone[Selphone No]) and show it against Month from date table.

Please mark it as answer if it resolves the issue. Kudos are also appreciated

[Anonymous]

Sorry, what if both SelPhone and date are columns in a same table how do we proceed.

I have an idea like take unique selphone so all repetitive customers are gone but the problem is how do I show that with respect to date.

It took me 5hrs but I am unable to find thanks for the quick reply.

[Shishir22]

You can still show that. 
Can you please share sample data(after hiding sensitive data) so that I can help you better?