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)

     

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.