Solved: Calculate with dates

vinicius_ramos · ‎02-13-2023

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:

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

Thanks a lot

Jihwan_Kim · ‎02-13-2023

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

View solution in original post

vinicius_ramos · ‎02-14-2023

Thanks a lot.

Jihwan_Kim · ‎02-13-2023

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

Calculate with dates