Forum Discussion

PowerBINewbie_1's avatar
PowerBINewbie_1
Icon for Helper I rankHelper I
8 years ago
Solved

Too many arguments were passed to the AND function. The maximum argument count for the function is 2

Hi,   Can anyone help. I'm trying to get this formula to run and I keep getting this error message:   Too many arguments were passed to the DATESBETWEEN function. The maximum argument count for t...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I believe you want:

     

    c_ARGB = 
IF(
	[ARG A]="",
	0,
	IF(
		[ARG D]="",
		CALCULATE(
			SUM(DateTable[WORKDAY]),
			DATESBETWEEN(
				DateTable[Date],
				'IC CMS List'[ARG A],
				TODAY()
			)
		),
		CALCULATE(
			SUM(DateTable[WORKDAY]),
			DATESBETWEEN(
				DateTable[Date],
				'IC CMS List'[ARG A],
				'IC CMS List'[ARG D]
			)
		)
	)
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Alt-Enter is your friend. That sends you to a new line within the DAX editing window. Or you can just copy and paste my formula.

PowerBINewbie_1's avatar
PowerBINewbie_1
Icon for Helper I rankHelper I
8 years ago

Thanks. I utilized the copy and paste keyboard shortcut and copied your solution. I'm still amazed. Again thanks.