Forum Discussion

HenryJS's avatar
HenryJS
Post 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 && 'Placements - (candidates)'[PlacementEndDate] < TODAY()) || ('Placements - (candidates)'[ExtensionEndDate] >= TODAY() -7 && 'Placements - (candidates)'[ExtensionEndDate] < TODAY()),1,0)
 
Thanks,
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)

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am confused with extention date and end date?

     

    Which date do you want in range?

     

    IF(('Placements - (candidates)'[PlacementEndDate] >=" 01/01/2020"&& 'Placements - (candidates)'[PlacementEndDate] <01/04/2020) ||

    ('Placements - (candidates)'[ExtensionEndDate] >= 01/01/2020 && 'Placements - (candidates)'[ExtensionEndDate] < 01/04/2020),1,0)

     

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

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

  • amitchandak's avatar
    amitchandak
    Super 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
      Post 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
        Super 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)