Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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])
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |