Forum Discussion
Condition column today+2
Hi Team,
I have a Date filed, I need to create a new column which gives me today -2.
Project OwnerDate
|
IF today is 07/19/2021, I should mark the dates 07/21/2021.
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!
3 Replies
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
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() )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!
