nextday empty value

[Anonymous]

I've the following report https://1drv.ms/u/s!Amd7BXzYs7AVlXPjuP0CfblYyc5K?e=lzqKkA

I'm trying to caculate value for current day and the value for the newt day 

for the lastest day why it's blank?

Any help will be appreciated

[Anonymous]

Are you looking for this ?

[Anonymous]

@Anonymous  yes exactly !! how you did it please 

[Anonymous]

@Anonymous  why 10/05 is shown in the picture, but you select 11/05 till july please?

[Anonymous · Accepted solution]

Hope this helps you here is the final measure

[hnguy71]

Hi @Anonymous ,

Your stockperdate only goes up to the current date and never the next day, hence the "next" day is always missing. To fix this, increase your max day by 1

If this is a base measure, and you have other measure dependencies, try to remove your date filters until you absolutely need it. Alternatively, you can create a separate measure for it.

[Anonymous]

If you remplace _Nextday by Today the last row will not remain blank.

Perhaps you have to work again ion the measure to get the difference done

[Anonymous]

yes, indeed, _today works correctly, but the issue is with _nextday. I'm not able to figure out the issue.

Than you 

[Anonymous]

Pour moi ca vient dans le calculde la date Nexday. Tu lui dis de prendre le Max de la date alors que nextday c'est la date du jour +1

Try this

[Anonymous]

thhe result is wrong; _next day should be 94 et _today = 94 so result should be 0 

[Anonymous]

@Anonymous what should I try it please?

Thank you very much for your help.

[Anonymous]

Sorry I made my respopnse in French

For me the problem is on the calculateion on next day.

Next is today +1 and on your measure you take only the max of the row, so you take today.

Look at the pprevious picture I sent I had changed the formula. Try it to see if it is ok for you

[Anonymous]

I tested, but it returns wrong results.

Thank you

[Anonymous]

I made a check, you have first to declare your Table date as date if you want time intelligence to work

[Anonymous]

Just beacause in your Perte measure you only return _Nextday, you did use switch to use _Nextay or Today

[Anonymous]

the goal is to calculate the diffrence between _today and _nextday, but I notice that that _next for the lastest date is always empty which is wrong.