The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi - I have the following scenario I am tying to solve.
The 'flag' column above is basically what we need to complish. Each time the status changes from Active to another status, we need to 'flag' it. So, customer 1 is flagged on 1/2/2019 and 2/5/2019. If we set a date filter to january 2019, we would have a count of 1 for customer 1.
I've seen one simliar question and solution but it does not contain a group by clause (customer in this case). Any help would be much appreciated.
Solved! Go to Solution.
This is a problem that involves EARLIER. See my article on Mean Time Between Failure (MTBF) which uses EARLIER (and "group by" essentially: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
This is a problem that involves EARLIER. See my article on Mean Time Between Failure (MTBF) which uses EARLIER (and "group by" essentially: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
Thanks for the nudge. Your blog plus a little help from the link below got me to the end result I needed.
https://powerpivotpro.com/2015/03/how-to-compare-the-current-row-to-the-previous-row-in-power-pivot/
Thanks again!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
91 | |
82 | |
64 | |
58 |
User | Count |
---|---|
246 | |
124 | |
115 | |
79 | |
78 |