topic Re: compare today date equal to another column date in DAX Commands and Tips

compare today date equal to another column date

Anonymous — Wed, 01 Jul 2020 11:41:38 GMT

How to compare (today date +1 equal to RequestClosedDate ) both are same return distinct count of Ticketno else 0

i have tried

Ticket-Closed-oneday =

var _DAY = DAY(MAX('Table'[RequestClosedDate]))

var _MONTH = MONTH(MAX('Table'[RequestClosedDate]))

var _YEAR = YEAR(MAX('Table'[RequestClosedDate]))

RETURN

CALCULATE(DISTINCTCOUNT('Table'[Ticketno]), FILTER('Table',DAY(TODAY()+1) = _DAY && MONTH(TODAY()) = _MONTH && YEAR(TODAY()) = _YEAR))

it's not working

Could you help with me these questions?

Thankful

Rajesh

Re: compare today date equal to another column date

amitchandak — Wed, 01 Jul 2020 13:50:50 GMT

Anonymous , try like

CALCULATE(DISTINCTCOUNT('Table'[Ticketno]), FILTER('Table','Table'[RequestClosedDate] = today()+1))

Re: compare today date equal to another column date

Mariusz — Wed, 01 Jul 2020 14:23:59 GMT

Hi Anonymous

Try this

Ticket-Closed-oneday = VAR __tomorrow = TODAY() +1 RETURN CALCULATE( DISTINCTCOUNT( 'Table'[Ticketno] ), 'Table'[RequestClosedDate] = __tomorrow )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

Re: compare today date equal to another column date

Anonymous — Wed, 01 Jul 2020 15:17:31 GMT

Hi Mariusz amitchandak

above you mentioned measures not working, its return blank value

suppose if i'm using column

Ticket-closed-oneday = IF ( TODAY ()+1 = DATE ( YEAR ( Taxone_SP1[RequestClosedDate]), MONTH ( Taxone_SP1[RequestClosedDate] ), DAY ( Taxone_SP1[RequestClosedDate] ) ),

Calculate(DISTINCTCOUNT(Taxone_SP1[Ticketno])),0)

it's showing duplicate ticket also, but i need unique ticket ID

Thanks

Rajesh