Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Within a table I am trying to get the rollling sum of each member, where the rolling sum is ordered by sale date. This is important to do a rolling sum vs. an overall total for each member because I need to identify the sales date at which a member hit above a certain $ threshold. Ex: identify when a member hit $200 total $,
Solved! Go to Solution.
PBI file attached. I have kept the threshold as 110.
Hope this helps.
This worked for the running total measure, but now I am trying to pull the first date of when the member's rolling total > 20k. Like the below screenshot, this member hit above 20k on 2/1/2024, so I want in my output a single line for each member to show the minimum date they hit above 20k and the overall sum of paid amount per member. The minimum date should not change once the member hits above 20k. I created a measure that identified when rolling paid amount > 20k then 1 else 0. When I filter on this measure = 1, I get those dates where the rolling paid amount is greater than 20k but I only want 1 row returned for each member with the minimum date when rolling paid amount > 20k.
Hi @ejoyce5
Please try this code :
Unfortunately this doesn't get to where I want to be. I have to have a column that shows the running total per member ordered by date, because what I am trying to do is flag for each row where a members total amount >= $200 and take the MIN date with the flag to show the date at which a member hit the $200 threshold
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |