Create Day Interval Columns

Hi marsclone,

Based on my test, you can refer to below steps:

1. I have entered some sample data like the picture below and I have calculated the [Datediff] column with this formula: Datediff = DATEDIFF('Sheet2'[Invoice Date],TODAY(),DAY)

2.Create four columns and you can see the correct result.

0~30 = IF('Sheet2'[Datediff]<=30,[Invoice Date])

31~60 = IF('Sheet2'[Datediff]<=30,BLANK(),IF('Sheet2'[Datediff]<=60,[Invoice Date]))

61~90 = IF('Sheet2'[Datediff]<=30,BLANK(),IF('Sheet2'[Datediff]<=60,BLANK(),IF('Sheet2'[Datediff]<=90,[Invoice Date])))

>90 = IF([Datediff]>90,'Sheet2'[Invoice Date])

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/qel02b27s4jp5bb/Create%20Day%20Interval%20Columns.pbix?dl=0

Regards,

Daniel He

Do you want to get the following tag results? If it is, you can use the DAX below:

Interval =
IF (
    Invoice[DayDiff] <= 30,
    "0-30",
    IF (
        Invoice[DayDiff] >= 31
            && Invoice[DayDiff] <= 60,
        "31-60",
        IF ( Invoice[DayDiff] >= 61 && Invoice[DayDiff] <= 90, "61-90", ">90" )
    )
)