Forum Discussion

asdf1608's avatar
asdf1608
Helper V
3 years ago
Solved

Compare between date and today

How do you compare month(date) and month(today).

The query is 

IF(month(date)<month(today) then Column1 else Column2

End

 

How to covnert this in Power BI

  • FreemanZ's avatar
    FreemanZ
    3 years ago

    It is like this:

    Column =
    IF(
        MONTH([Date]) = MONTH(TODAY()),
        Column1,
        Column2
    )

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    It is like this:

    Column =
    IF(
        MONTH([Date]) = MONTH(TODAY()),
        Column1,
        Column2
    )