Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Date Range DAX

Hi all,   How do I change the below DAX to specfic dates?   I want it to be between 01/01/2020 and 01/04/2020   Finishers = IF(('Placements - (candidates)'[PlacementEndDate] >= TODAY() - 7 && ...
data protection
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Check

    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 this 04 is April

    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)

     

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi amitchandak 

 

This didn't return the right values

 

Below is what I'm after. Two columns

 

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

Check

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 this 04 is April

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)