How to get usage of at least two times in one week

[Balaraju]

Hi All,

Actually in my table I have User id and FB usage Columns I need to get How many Distinct  users used  FB usage at least two times per every week the month data is in daily level.

Eg: If there is 4 weeks this month, 2 times every of these weeks if I only access 3 out of 4 weeks, its not to be counted.

Sample Table:

[Anonymous]

Hi @Balaraju ,

First we need a date column and use this to calculate the week number.

Date = DATE('Table'[Year],'Table'[Month],'Table'[Day])

Week = WEEKNUM('Table'[Date])

Then calculate the quantity that meets the requirements.

Column 1 = IF('Table'[FB Usage]>2,'Table'[User Id]) 

Column 2 = 
VAR _value_1 =
    CALCULATE (
        DISTINCTCOUNTNOBLANK ( 'Table'[Column 1] ),
        ALLEXCEPT ( 'Table', 'Table'[Week] )
    )
RETURN
    SWITCH ( TRUE (), _value_1 <> 0, _value_1, 0 )

The result should be like this.

Attach the PBIX file for reference. Hope it helps.

If this doesn't work for you or I misunderstand your needs, please consider sharing more details about it. And it would be great if there was a sample file without any sensitive information here.

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar.
2. Expected output from sample data.
3. Explanation in words of how to get from 1. to 2.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Balaraju]

Hi @Anonymous ,

Actually it is not matiching my requirement. Thanks for your Reply. I will reshare my requirement again.