New Column Date Filter

[HenryJS]

Hi all,

How can I create two columns for the below expression

Starters =

• IF ‘Export Placements’[PlacementDate] is between 01/01/2020 & 01/04/2020
• THEN 1

Finishers =

• ‘Export Placements’[PlacementEndDate] is between 01/01/2020 & 01/04/2020
• OR ‘Export Placements’[ExtensionEndDate] is between 01/01/2020 & 01/04/2020
• THEN 1

[amitchandak · Accepted solution]

Try

Starters =IF ('Export Placements'[PlacementDate] >=date(2020,01,01)
					&& 'Export Placements'[PlacementDate] <=date(2020,01,04),1,0)
Finishers = IF (('Export Placements'[PlacementDate] >=date(2020,01,01)
					&& 'Export Placements'[PlacementDate] <=date(2020,01,04))
				|| ('Export Placements'[ExtensionEndDate] >=date(2020,01,01)
					&& 'Export Placements'[ExtensionEndDate] <=date(2020,01,04))	
					,1,0)

If 04 means april the move it second position

Starters =IF ('Export Placements'[PlacementDate] >=date(2020,01,01)
					&& 'Export Placements'[PlacementDate] <=date(2020,04,01),1,0)
Finishers = IF (('Export Placements'[PlacementDate] >=date(2020,01,01)
					&& 'Export Placements'[PlacementDate] <=date(2020,04,01))
				|| ('Export Placements'[ExtensionEndDate] >=date(2020,01,01)
					&& 'Export Placements'[ExtensionEndDate] <=date(2020,04,01))	
					,1,0)