topic Re: Need help in DAX in DAX Commands and Tips

Need help in DAX

Anonymous — Sun, 15 Jan 2023 16:26:35 GMT

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

Re: Need help in DAX

Nathaniel_C — Sun, 15 Jan 2023 16:44:09 GMT

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

Re: Need help in DAX

Nathaniel_C — Sun, 15 Jan 2023 16:46:29 GMT

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

Re: Need help in DAX

Anonymous — Sun, 15 Jan 2023 17:56:16 GMT

Thanks Nathaniel_C for your quick reply, unfortunately your code is not helping to get the Max date. I don't understand why my date is not getting the MAX date from the Date column. pls help. It should filtered out 01/15/23.

Re: Need help in DAX

Nathaniel_C — Sun, 15 Jan 2023 18:59:44 GMT

Hi Anonymous ,
What are you trying to do? When I read your first post, my understanding is that you wanted to compare each create date and compare it to today's date. If it matches, mark it Y in a new column, or if it does not, mark it N. Which is what I did. If that is not what you are looking for, please give us a visual for your expected results. You can dummy this up in Excel if you need to do so.

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

Re: Need help in DAX

Nathaniel_C — Sun, 15 Jan 2023 19:16:01 GMT

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