Forum Discussion

pan's avatar
pan
Frequent Visitor
8 years ago

Running total then return date when target is reached?

Hi!   I have data arranged as follows:   Year, Product , Gross Sales   I then created measures for Rolling Averages (for preceding three years. This serves as the Target), Running totals (would...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

pan

 

You should apply all dates as row context in FILTER() function to compare two measures. 

 

AchieveDay = CALCULATE(MIN(Table4[Date]),FILTER(ALL(Table4[Date]),[ytd]>[AVG]))

 

Regards,

 

pan's avatar
pan
Frequent Visitor
8 years ago

Hi! Thanks for your response. But I also want to filter by product. Using your formula, it only returns the same date regardless of the product. I'm sorry I'm really new to Power BI