cancel
Showing results for
Did you mean:
Highlighted
Helper III

## compare today date equal to another column date

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

3 REPLIES 3
Highlighted
Super User IX

## Re: compare today date equal to another column date

@RajeshRanganath , try like

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

Proud to be a Super User!

Highlighted
Super User V

## Re: compare today date equal to another column date

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.

Highlighted
Helper III

## Re: compare today date equal to another column date

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021