Bin days since sale

[Anonymous]

Hi all,

I have this file attached where there is one column with numbers 1-450

What I would like to do is create a slicer that will filter this columns data based off how was days ago the sale was. 

the filter would include these options:

last29days

last60days

last120days

over120days

what is the best way to approach this?

thank you all!

SampleFIle

[Anonymous · Accepted solution]

@Anonymous 

Try create the a slicer table and a measure. See the pbix file.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

thank you this is exactly what I was looking for

[amitchandak]

@Anonymous , check if this can help

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization