Forum Discussion

vjsingh2012's avatar
vjsingh2012
Regular Visitor
6 years ago

Data Grouping_Query...

Hi experts,   I am a learner of Power BI and Power Pivot. So forgive me if my query looks silly.    So here is my query. I have a dataset with three columns Months, Regions & Revenue. We have alm...
aaa
vjsingh2012's avatar
vjsingh2012
Regular Visitor
6 years ago

Thank you Camargos....completely resolved my query. Thanks

 

However, we have got a change request in deciding Tier. Earliar we were taking sum of last three months and than checking Tier criteria. Now we have to take average of last two quarter and than establish the tier with the same Tier Amount as before. 

 

I tried to do it myself with the Average/AverageX both function but getting error. 

 

Thanks again for helping.

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi vjsingh2012 ,

 

Try changing the number os months and instead of sum -> average.

 

Ricardo