Forum Discussion

PatrickByGecko's avatar
PatrickByGecko
Helper V
6 years ago
Solved

Probleme when Evaluating dates

Hello I get a problem when comparing to dates, Is this instruction correct?   VAR _DateBeginMonth = DATEVALUE("01/" & MONTH(TODAY()) & "/" & YEAR(TODAY())) VAR _DateBeginFinal = if ( 'TABLE'[DA...
Need Help
  • PatrickByGecko's avatar
    PatrickByGecko
    6 years ago

    Hi

    I did put my conditions inside the FIlter command and it is OK. It is not a beautiful code but it works...

    Thank you again.

PatrickByGecko's avatar
PatrickByGecko
Helper V
6 years ago

 

When I display the values so as to check

VAR _DateBeginMonth = 43922 and 'TABLE'[DATE BEGIN] = 43942. So the problem must coming from the syntax of comparison. I think..

 

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Okay, these are the dates you are comparing