I want to create days bucket

[Vijayqlik4171]

Spoiler

Spoiler

I have fields 

Invoice date ,
Total outstanding

Can we create bucket like 

0-100 days 

100-300 days 

300-500 days

500days & more

[Vegar · Accepted solution]

You can do this by creating four expressions/measures

0-99 day bucket
sum({<[Invoice date]={">$(=today()-100)<=$(=today())"}>}[Total outstanding]) 

100-299 day bucket
sum({<[Invoice date]={">$(=today()-300)<=$(=today()-100)"}>}[Total outstanding])

300-499 day bucket
sum({<[Invoice date]={">$(=today()-500)<=$(=today()-300)"}>}[Total outstanding])

More then 500 days bucket
sum({<[Invoice date]={"<=$(=today()-500)"}>}[Total outstanding])

[Vijayqlik4171]

Thank you vegar

[Vijayqlik4171]

Can we create field in backend instead of set analaysis

[Vegar]

You can create buckets backend using intervalmatch. See sample below.