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, I have a measure I'm trying to create that displays the total amount a user has earned over time, but it should only display this value for the dates they were considered active. Each user is associated with a partner and I want to display the total amount for the partner for any given month in the table. If the month is after when they were active then that user's total won't be included for the partner. While a user is active it will include all of their earnings up to that date, like a running total.
I am not getting an error message but it isn't working correctly.
The measure:
Relationships:
This is the current result which I know is incorrect. There should be some values and more partners.
This is the table with all the partners before trying to add in the measure.
I have spent over 12 hours trying to get this to work. Any idead would be very appreciated.
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |