topic Re: Today() and Now() is not working for a DAX function in DAX Commands and Tips

Today() and Now() is not working for a DAX function

Irbaz — Wed, 11 May 2022 05:36:39 GMT

I have a table and I want to filter out the records which are due in 90 days, I used the following DAX query but now() and today() function is not working, I have tried both

Table 2 = Filter(

'Table',

DateDiff(

NOW(),

'Table'[Latest Date],

Day

) <=90

)

** How can I add a new column with values (overdue, due) on the basis of date.

Document Type	Latest Date
Certificate 1	3/1/2022
Certificate 2	1/31/2024
Layout Design	7/1/2022
Statement 1	7/1/2022
Statement 2	3/1/2022
Processes Description	10/1/2024
Flow Diagram	10/1/2024
Floor Plan	7/1/2022
Schedule 1	1/31/2024
Schedule 2	7/1/2022
List 1	7/1/2022
List 2	7/1/2022
Schedule A	3/1/2022
Schedule Y	3/1/2022
Schedule G	3/1/2022

Re: Today() and Now() is not working for a DAX function

amitchandak — Wed, 11 May 2022 06:04:20 GMT

Irbaz , try like

Table 2 = Filter(
'Table','Table'[Latest Date] >=Today() -90 && 'Table'[Latest Date] <=today())

Now has time also, today is only date

Re: Today() and Now() is not working for a DAX function

Irbaz — Wed, 11 May 2022 06:55:08 GMT

amitchandak Thank you for your reply,

How can I create 2 columns ("overdue" and "due in 90 days") with values TRUE and FALSE,

Re: Today() and Now() is not working for a DAX function

Anonymous — Mon, 16 May 2022 02:40:32 GMT

Hi Irbaz ,

Try codes as below to create calculated columns.

Overdue = VAR _DATEDIFF = DATEDIFF ( TODAY (), 'Table'[Latest Date], DAY ) RETURN IF ( _DATEDIFF < 0, TRUE (), FALSE () )

Due in 90 days = VAR _DATEDIFF = DATEDIFF ( TODAY (), 'Table'[Latest Date], DAY ) RETURN IF ( _DATEDIFF >= 0 && _DATEDIFF <= 90, TRUE (), FALSE () )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.