typical range use case

[Anonymous]

hi have the typical user where i need to comapre the some labels data of tshirt manufacturing company . where i need to check the price of individual tshirt with the range mentioned in the table . and company want to know the trend if the label printed is within the allocated ranges designed by the company or not . what is the best way to represent this ?

data looks like:

date   brand    price    minprice maxprice

10/2/2017  polo us      145    120         200

10/3/2017    nike         30    0              50

10/3/2017    addidas    45   30           60

actaully need to see the variance  label vs price allocated with in the date range . how this can be designed any one came up with this use case ?

[v-danhe-msft]

Hi @Anonymous ,

What is your desired result? Could you please post it if possible?

Regards,

Daniel He

[d_gosbell]

You should be able to do this with the dynamic banding approach from daxpatterns.com see https://www.daxpatterns.com/dynamic-segmentation/