Calculating sum of values per user using user specific date period

[GvidoB]

Hi everybody,

I'm quite new to Power Bi and am struggling with this task:

Calculating value generated of every user in the first 30 days since the Created_At date.

Here' s how my data looks like:

The result would be:

User_Id 1234 - $11.00

User_Id 1235 - $25.00

User_Id 1236 - $0.00

I'm not even sure how to begin with this - with a calculated collumn next to users table or with a measure. I've managed to do this using Excel without problems, but would like to transfer the calculations to Power Bi. I have set up the relationships between the tables.

Would appreciate some tips or hints how to tackle this.

Thanks a lot in advance!

Gvido

[Phil_Seamark · Accepted solution]

HI @GvidoB

This calculated measure gets pretty close and doesn't rely on any relationships.  I have attached a copy of the PBIX file.

Measure = 
VAR x = 
    GENERATE(
        User,
        FILTER(
            'Orders',
            'Orders'[User_Id] = User[User_ID] && 
            'Orders'[Sent_At] < 'User'[Created_At] +30
            )
            )
RETURN SUMX(x,[Value])

[GvidoB]

Thank you, @Phil_Seamark !

This works perfectly.