Month/Year of Today ()

[PBI_newuser]

Hi,

There is error for the below Column, please advise if MONTH (TODAY()) and YEAR (TODAY()) can't be used here.

Error message:

DAX comparison operations do not support comparing values of type Text with values of type Integer.

Consider using the VALUE or FORMAT function to convert one of the values.

Flag = IF(Table[Due_Date]=BLANK(),1,
          IF(OR(AND(Table[Due_Date].[Month]=MONTH(TODAY()),Table[Due_Date].[Year]=YEAR(TODAY())),
               TODAY()<Table[Due_Date]),
                  0,1))

[amitchandak · Accepted solution]

@PBI_newuser , Try like

Flag = IF( isblank(Table[Due_Date]),1,
IF(OR(AND( month(Table[Due_Date])=MONTH(TODAY()),year(Table[Due_Date])=YEAR(TODAY())),
TODAY()<Table[Due_Date]),
0,1))

Hope due_date is identified as date

[sktneer · Accepted solution]

Table[Due_Date].[Month] will return Month Name and MONTH(TODAY()) will return the Month Number and they cannot be compared.

Therefore do a comparison between MONTH(Table[Due_Date]) and MONTH(TODAY()) because they both would return Numbers.

[amitchandak · Accepted solution]

@PBI_newuser , Try like

Flag = IF( isblank(Table[Due_Date]),1,
IF(OR(AND( month(Table[Due_Date])=MONTH(TODAY()),year(Table[Due_Date])=YEAR(TODAY())),
TODAY()<Table[Due_Date]),
0,1))

Hope due_date is identified as date