Forum Discussion

tomringer's avatar
tomringer
Frequent Visitor
9 years ago
Solved

Cumulative chart not rendering correctly after refresh.

Hi,

I am having an issue with some cumulative/ period to date measures. They appear how i want them on teh desktop version and, untill I installed a gateway to refresh daily, rendered correctly on pbI.com. However since installing the gateway the current year has gone awry. The only thing I can think of is that it's something to do with the date format being different on desktop or online. Any ideas? Here is the measure I am using

 

MTD Sales Cumulative = CALCULATE(SUM(Append1[LineTotalValueBase]),Filter(ALLSELECTED(Append1),'Append1'[Year] = MAX('Append1'[Year]) && 'Append1'[OrderDate]<=Max('Append1'[OrderDate])))

 

Thanks, Tom

  • tomringer's avatar
    tomringer
    9 years ago

    Thanks for getting back to me Qiuyun Yu.

     

    I have solved the issue, which wasn't connected to the date/ time format after all. I was pulling the data through from two different sources - one a static historical worksheet and the other from a live sage query. It turns out a sage developer had changed the format of the value field from whole decimal to $ meaning I wasn't joing, and subsequently summing teh same data types. It's all good now though :smileyhappy:

     

    Best wishes,

    Tom

2 Replies

    • tomringer's avatar
      tomringer
      Frequent Visitor
      9 years ago

      Thanks for getting back to me Qiuyun Yu.

       

      I have solved the issue, which wasn't connected to the date/ time format after all. I was pulling the data through from two different sources - one a static historical worksheet and the other from a live sage query. It turns out a sage developer had changed the format of the value field from whole decimal to $ meaning I wasn't joing, and subsequently summing teh same data types. It's all good now though :smileyhappy:

       

      Best wishes,

      Tom