Condition column today+2

[Anonymous]

Hi Team,

I have a Date filed, I need to create a new column which gives me today -2.

Project OwnerDate

Project
1	A	7/21/2021
2	B	7/15/2021
3	C	7/17/2021
4	D	7/18/2021
5	E	7/21/2021
6	F	7/20/2021
7	G	7/22/2021
8	H	7/19/2021
9	I	7/21/2021

IF today is 07/19/2021, I should mark the dates 07/21/2021.

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

You can use conditional formatting.

Create measure as:

Measure = 
IF(
    MAX('Table'[Date])=TODAY()-2,
    1,
    0
)

Here is the output:

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Fowmy]

@Anonymous 

Did not understand but if you need to create a column as follows, then this should work

New Column = =IF ( Table[Date] = today()+2 , Table[Date] , blank() )

[Anonymous]

I wanted to do something like this before. I found this forum post.

Solved: older than 3 months measure - Microsoft Power BI Community

I'm sure if you changed the MONTH to DAY you would be able to get the answer you wanted