Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX comparison operations

Hi, I am new to DAX and Power BI and I having some problems with the bellow formula. INF - IF ([DateTime ]«DATE (YEAR (TODAY ()), MONTH (TODAY ()), 1), 1, 0) DAX comparison operations do not suppo...
DAX
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,

    Yes, you are correct. The text data type was DateTime. I figured it out by adding Value(DateTime).

    INF = IF (Value([DateTime ])«DATE (YEAR (TODAY ()), MONTH (TODAY ()), 1), 1, 0).

    Thank you for replying to my message. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
Which one is the text data taype column?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

Month is the text data type