Forum Discussion

kmilarov's avatar
kmilarov
Helper II
2 years ago
Solved

Comparing two date/time columns form two different tables queries

Hi Guys, I havre two table queries with diffrent data/columns. But both tables have column : date/time . It shows the time when the particular dataste/source file for each query was created. So, the...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    kmilarov Not sure I completely understand but maybe this?

    MatchDates = 
  VAR __utilDate = MAX('Util'[Date created])
  VAR __limitsDate = MAX('Limits'[Date created])
  VAR __Result = IF( __utilDate = __limitsDate, 1, 0 )
RETURN
  __Result
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

kmilarov Not sure I completely understand but maybe this?

MatchDates = 
  VAR __utilDate = MAX('Util'[Date created])
  VAR __limitsDate = MAX('Limits'[Date created])
  VAR __Result = IF( __utilDate = __limitsDate, 1, 0 )
RETURN
  __Result