I need help in my current dax which i cannot add Today () +1 which I tried its not working.

[mdaamirkhan]

Hi All,

I need help in my current dax which i cannot add Today () +1 which I tried its not working. How will I added Today () +1 in my current dax to so that it will add Today() +1 in the Number of current days

Query below:
Number of current days:  ABS(DATEDIFF([MaxDate],TODAY(),DAY)+2)

[v-yuaj-msft]

Hi @mdaamirkhan ,

Have you tried to use modified your DAX expression as follows?

ABS(DATEDIFF([MaxDate],TODAY()+1,DAY)+1)

If it doesn't work, please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.

Best Regards,

Yuna

[amitchandak]

@mdaamirkhan , Not very clear 

Usually +1 should

Try like. Mobed ABS before addition

Number of current days: ABS(DATEDIFF([MaxDate],TODAY(),DAY))+1

or

Number of current days: ABS(DATEDIFF([MaxDate],TODAY(),DAY))+2

[mdaamirkhan]

not working 

[amitchandak]

@mdaamirkhan ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[mdaamirkhan]

cannot share the pbix or data