Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |