Create Column If date falls within next week

Question

Hi all,&nbsp; I am very new to Power BI.&nbsp; I am trying to create a column which indicates if my planned date column/field falls within the next week or 7 days.&nbsp; I need it to result in a number 1 else 0.&nbsp; Can someone help me?&nbsp; I have tried an If statement, but still can't figure it out.&nbsp;Planned DateComing Due Next week11/10/2021112/3/20210

amitchandak · Accepted Answer

kza40381 , Try a new column like
&nbsp;
New Column = if([Planned Date]&gt;= Today() &amp;&amp; Planned Date] &lt;= today() +7,1,0)
&nbsp;

Forum Discussion

Create Column If date falls within next week

1 Reply

Related content

Create columns group

Creating a date column

Creating a custom column

unpivoting columns and creating datetime column

create custom column concatenated

Planned Date	Coming Due Next week
11/10/2021	1
12/3/2021	0