Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Problem with segmentation / grouping up data

Hello,   I am using powerpivot to analyse data for an internship. I have an normal dataset with one factstable with all the orders, one costumer table with the costumer names, country etc. and one ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Try this measure

 

=IF(HASONEVALUE(Data[Customer]),IF([Revenue]<250000,"Low",IF([Revenue]<=1000000,"Medium","High")),BLANK())

 

Hope this helps.