Forum Discussion
Alternative to Binning
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?
2 Replies
- amitchandak
Super User
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-kDynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
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?
