Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

nextday empty value

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hope this helps you here is the final measure

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

     

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

      Than you 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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

  • hnguy71's avatar
    hnguy71
    Super User
    4 years ago

    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's avatar
    Anonymous
    Not applicable
    4 years ago

    Are you looking for this ?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Anonymous  yes exactly !! how you did it please 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

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