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)

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try

Finishers = IF(('Placements - (candidates)'[PlacementEndDate] >= date(2020,1,1) 
			&& 'Placements - (candidates)'[PlacementEndDate] < date(2020,1,4)) 
			|| ('Placements - (candidates)'[ExtensionEndDate] >= date(2020,1,1) 
			&& 'Placements - (candidates)'[ExtensionEndDate] < date(2020,1,4)),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)

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi HenryJS 

      Create below 2 columns

      Starters=If(‘Export Placements’[PlacementDate]>=Date(2020,1,1) &&‘Export Placements’[PlacementDate]<=Date(2020,4,1),1)

       

      Finishers=If((‘Export Placements’[PlacementEndDate]>=Date(2020,1,1) &&‘Export Placements’[PlacementEndDate]<=Date(2020,4,1))||

      (‘Export Placements’[ExtensionEndDate]>=Date(2020,1,1) &&‘Export Placements’[ExtensionEndDate]<=Date(2020,4,1)),1)

       

      Thanks & regards,
      Pravin Wattamwar
      www.linkedin.com/in/pravin-p-wattamwar

      If I resolve your problem Mark it as a solution and give kudos.