Calculate with dates

[vinicius_ramos]

Hello,

I have a table that have 5 dates and I need a function that bring me what date it's inside the last five days.

For example: 

Number	Date	Results
1	2023-13-01	0
2	2023-15-01	0
3	2023-13-02	1
4	2023-08-02	0
5	2023-03-02	0

I need a Function that calculate if the colunm "Date" in the last 05 days, bring number 1, case not, 0.

Thanks a lot

[vinicius_ramos]

Hello @Jihwan_Kim 

Thanks a lot.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Result CC =
(
    TODAY () - 5 <= Data[Date]
) * 1