Forum Discussion
Razorbx13
Post Patron
Post PatronQuestion on Calculations
I have the below data. What I need to do is track total sales and total transactions, and when either of these go over their threshold then the date gets placed in the Date Threshold Met, but it is ...
jthomson
Solution Sage
Solution SageWithout seeing your data more clearly, I'd guess the way to do it would be to make some sort of cumulative sum measure on sales for the month, then work out the lowest value for where that measure is higher than your threshhold value?
parry2k
Super User
Super UserRazorbx13 Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490