Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help in DAX

Experts, please help me to fix the below DAX code. I am trying to compare/equal to date passing from create data with todays date, it is throwing the error. pls help    
@Daxhelp
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    Hi Anonymous ,
    If what you are trying to do is to filter out today's date,  drop the measure in the filter pane for this visual as in the picture below. = N will get you every date but today, Y will get you only today.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous ,

Try this please:

Date compare = IF(MAX(compare[Date]) = TODAY(), "Y", "N")

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel