Forum Discussion
Question 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 ...
Without 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?
Razorbx13 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