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 need to determine which are the Route numbers that have an associated Number greater than 50 for 3 successive Dates. In this example, the Route 4, 6 and 7 have Numbers greater than 50 for 3 successive Dates.
Thanks for your help.
Solved! Go to Solution.
@Ugo You are going to want something like Cthulhu or MTBF might also provide a pattern:
Cthulhu - Microsoft Power BI Community
Mean Time Between Failure (MTBF) - Microsoft Power BI Community
Both are for doing row-wise comparison operations (which is not trivial in DAX)
Seems route 11 is also has 3 values greater than 50. For your requirement, you could first create a flag column then create a result column.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Thanks for the solution. However, route 11 does not have three consecutive results greater than 50. There is a result of 30 on August 18th.
@Ugo You are going to want something like Cthulhu or MTBF might also provide a pattern:
Cthulhu - Microsoft Power BI Community
Mean Time Between Failure (MTBF) - Microsoft Power BI Community
Both are for doing row-wise comparison operations (which is not trivial in DAX)
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |