Active user through order date

Hi Anonymous ,

 

You can try this method:

 

New columns:

(UserID) 1 = IF(DATEDIFF(CALCULATE(SUM(Orders[Invoice date]), FILTER('Orders','Orders'[UserID] = 1)), 'Table'[Date],DAY) <= 30, TRUE(),FALSE())

(UserID) 2 = IF(DATEDIFF(CALCULATE(SUM(Orders[Invoice date]), FILTER('Orders','Orders'[UserID] = 2)), 'Table'[Date],DAY) <= 30, TRUE(),FALSE())

(UserID) 3 = IF(DATEDIFF(CALCULATE(SUM(Orders[Invoice date]), FILTER('Orders','Orders'[UserID] = 3)), 'Table'[Date],DAY) <= 30, TRUE(),FALSE())

The result is:

 

Or there are an another method. I agree with the amitchandak  to create a new table and a new measure, then use matrix visual:

New table:

Table 2 = CALENDAR(TODAY()-3, TODAY())

New measure:

Measure1 =
CALCULATE (
    SUM ( 'Orders'[Revenue] ),
    FILTER (
        'Orders',
        DATEDIFF ( 'Orders'[Invoice date], MAX ( 'Table 2'[Date] ), DAY ) <= 30
    )
)
    <> BLANK ()

And use matrix visual:

 

 

 

 

 

Hope this helps you. Here is my PBIX file.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.