Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

New Column Date Filter

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 Placemen...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    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)
amitchandak's avatar
amitchandak
Super User
6 years ago

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)