Dax give message can't use True and False condition

[mohittimpus]

CALCULATE(COUNT(customer[ID]),DATE(YEAR(TODAY())-1,DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))+TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))+dayInc))

var dayInc =
IF (
OR (
MOD ( YEAR ( SELECTEDVALUE ( customer[DATE] ) ), 400 ) = 0,
AND (
MOD ( YEAR ( SELECTEDVALUE ( customer[DATE] ) ), 4 ) = 0,
MOD ( YEAR ( SELECTEDVALUE ( customer[DATE] ) ), 100 ) <> 0
)
),
IF (
MONTH ( SELECTEDVALUE ( customer[DATE] ) ) = 1
|| MONTH ( SELECTEDVALUE ( customer[DATE] ) ) = 2,
1,
2
),
IF (
OR (
MOD ( ( YEAR ( SELECTEDVALUE ( customer[DATE] ) ) - 1 ), 400 ) = 0,
AND (
MOD ( ( YEAR ( SELECTEDVALUE ( customer[DATE] ) ) - 1 ), 4 ) = 0,
MOD ( ( YEAR ( SELECTEDVALUE ( customer[DATE] ) ) - 1 ), 100 ) <> 0
)
),
IF (
MONTH ( SELECTEDVALUE ( customer[DATE] ) ) = 1
|| MONTH ( SELECTEDVALUE ( customer[DATE] ) ) = 2,
2,
1
),
1
)
)

-------------------------------

I want to count of Value last year same week day till specifec time or currect time.

For Exmaple:  Today Date and Time will be:  09-05-2020 17:25  ----  I want count of last year till same time : 11 -05-2029 till 17:25.

[Greg_Deckler]

OK, it doesn't look like you even have three parameters for your first DATE function. The second parameter looks to be a return from a DATE function. This is all bad.

CALCULATE(
	COUNT(customer[ID]),
	DATE(
		YEAR(TODAY())-1,
		DATE(
			YEAR(TODAY())-1,
			MONTH(TODAY()),
			DAY(TODAY())
		)
		+
		TIME(
			HOUR(NOW()), 
			MINUTE(NOW()), 
			SECOND(NOW())
		)
		+
		dayInc
	)
)

[Mayank08]

When i useed your dax that give error message one "day" parameter is missing. 

I need use this date like this 

CALCULATE(

    COUNT(customer[ID]),

        DATE(

            YEAR(TODAY())-1,

            MONTH(TODAY()),

            DAY(TODAY())

        )

        +

        TIME(

            HOUR(NOW()),

            MINUTE(NOW()),

            SECOND(NOW())

        )

        +

        dayInc

    )

but this give this error message. 

"The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column."

[az38]

Hi @Mayank08 

you need compare your date with some filter. The second argument in CALCULATIE() is filter rule that can return boolean and not date, number or text

[Mayank08]

@az38 
Yes try fillter function but thi not work give over count. 

when i use this Dax this work good with Date but not with time. I just need help work with time

CALCULATE(

COUNT(customer[ID]),

    DATESBETWEEN(dateTable[Date],

        DATE(

            YEAR(TODAY())-1,

            MONTH(TODAY()),

            DAY(TODAY())

        )

        +

        TIME(

            HOUR(NOW()),

            MINUTE(NOW()),

            SECOND(NOW())

        )

        +

        dayInc,

    DATE(

            YEAR(TODAY())-1,

            MONTH(TODAY()),

            DAY(TODAY())

        )

        +

        TIME(

            HOUR(NOW()),

            MINUTE(NOW()),

            SECOND(NOW())

        )

        +

        dayInc

))

[az38 · Accepted solution]

@Mayank08 

try like

Measure = 
var _Date =  
        DATE(
            YEAR(TODAY())-1,
            MONTH(TODAY()),
            DAY(TODAY())
        )
        +
        TIME(
            HOUR(NOW()),
            MINUTE(NOW()),
            SECOND(NOW())
        )
        +
        dayInc

RETURN

CALCULATE(
    COUNT(customer[ID]),
    dateTable[Date] >= _Date
)

[mohittimpus]

@az38 @Greg_Deckler 

I want this to be count. 

For Exmaple:  Today Date and Time will be:  09-05-2020 17:25  ----  I want count of last year till same time : 11 -05-2029 till 17:25.

That measure i am using it work with date level but not with time. so can you plz help on this

return CALCULATE(COUNT(customer[ID]),

DATESBETWEEN(dateTable[Date],

DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))+dayInc,

DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))+dayInc))

[mohittimpus]

@az38  Thanks it work when i use like this way

var _Date =

DATE(

YEAR(TODAY())-1,

MONTH(TODAY()),

DAY(TODAY())

)

+

TIME(

HOUR(NOW()),

MINUTE(NOW()),

SECOND(NOW())

)

+

dayInc

var _Date1 =

DATE(

YEAR(TODAY())-1,

MONTH(TODAY()),

DAY(TODAY())

)

+

TIME(

HOUR(00),

MINUTE(00),

SECOND(00)

)

+

dayInc

RETURN

CALCULATE(

COUNT(customer[ID]),

customer[DateCreated] <= _Date,customer[DateCreated] >= _Date1

)

[az38]

@mohittimpus 

so, now its ok?

if so, please, mark appropriated solution to close the topic