Alternative to Binning

[tropic]

I am creating a dashboard and one of the objectives is to know how much of our current stocks will expire in the succeding months. Basically, we wanted to have a visibility up to 6 months, so when we filter to a certain date, we'll count 30 days, and see how many are expiring in a month, 60 days for two months and so on. 

we thought binning would work but i am not sure if it is as flexible as we wanted it to be. any alternatives we can use?

[tropic]

Hi, the measure you shared does not work, unfortunately. I understand that I need to first get the difference between the two dates before I can segment them and put them in a bin. Can you help me with the needed measure/column for the datediff? 

[amitchandak]

@tropic , if you want based in today, then binning or static column can do. if you need based on selected date you need use dynamic segementation

Your measure will be

datediff(max(Table[Due Date], maxx(allselected(Date), Date[Date]) , Month)

then

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ