Forum Discussion

Rubal_Islam's avatar
Rubal_Islam
Icon for Helper II rankHelper II
2 years ago
Solved

Need help with- Max Date vs Current Month

Hi Braintrust,   Need your help with the below DAX.   It is currently returning 1 or 0 if the date is  Max date. However, I would like it to return 1 if the date is the current month and 0 for a...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    pls try

    if(year(max(dim_date[full_date]))=year(today())&&month(max(dim_date[full_date]))=month(today()),1,0)

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

pls try

if(year(max(dim_date[full_date]))=year(today())&&month(max(dim_date[full_date]))=month(today()),1,0)

Rubal_Islam's avatar
Rubal_Islam
Icon for Helper II rankHelper II
2 years ago

hi Ryan, it works fine. thank you soo much for your help. legend.

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    you are welcome