Forum Discussion

asdf1608's avatar
asdf1608
Icon for Helper V rankHelper 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
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

It is like this:

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