Grouping and charting data from a measure

[RedBe]

Hello, 

Ultimately I am trying to filter my measure I have created for days of stock. the measure I used is a simple one 

days of Stock = DATEDIFF( DATE(2022,07,29), 'Weekly usage schedule'[Date out of Stock], DAY).

It's a measure from another created for an out of stock date. 

The measure gives me the data I need, but what I want to do with it is to now group it up into certain categories and display it e.g, 0-30 days, 30-90days, etc.

Is it possible to create a column somehow with this same formula? When I try it it isn't giving me the correct values. 

Can anyone help me map out how to go about this.   

[v-yalanwu-msft · Accepted solution]

Hi, @RedBe ;

Try it.

group = 
var _daysStock =
DATEDIFF (
    DATE ( 2022, 07, 29 ),
    'Weekly usage schedule'[Date out of Stock],
    DAY)
return IF(_daysStock>=0&&_daysStock<30,"0-30 days",IF(_daysStock>=30&&_daysStock<90,"30-90days",IF(_daysStock>=90,"> 90days")))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.