If Date = Today

[NewbieJono]

Hello, i have a column with a list of dates. what DAX would i use to check if the MAX date in the data coloumn is today, if it is then display todays date. if not then display "No data"

could i create this as a measure and not a calculate coloumn

[nvprasad · Accepted solution]

Hi,

You can use below Dax

IF (CALCULATE(MAX(DATE),ALL(TABLENAME)) = TODAY(), TODAY(),"NO DATA")

I have added "ALL" function to ignore filters coming from outside.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad