Forum Discussion

vipett's avatar
vipett
Icon for Helper III rankHelper III
4 years ago
Solved

Calculate sum on a given date

I have a crossjoined table with all dates and all my articles and then I have one column where I store all my transactions, plus and minus (which do not occur every day).   Through this measure:  ...
Need Help
  • vipett's avatar
    vipett
    4 years ago

    Okey, so I found an really ugly way of solving it, but at least it works..

    I added a table and just entered 2022-12-31 in one cell, then created a new measure where I calculated the previous measure and put that the date should be equal to the sum in that new table.. 

    Don't really understand why I couldn't say that date = 2022-12-31 but yeah.. it works now at least. But there might be a nicer solution..

     

    End of Year = CALCULATE([SOH]2, JB[CalenderDate]=SUM('EndOfYear'[Column1]))
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Share the link from where i can download your PBI file.

vipett's avatar
vipett
Icon for Helper III rankHelper III
4 years ago

Here is an example file I did with fake data.

https://filepost.io/d/M4fRbY5sQe

 

So for this case, I would like to have a measure that only gives me the result for 2022-09-30.

I can of course put it in a table and set the date to 2022-09-30, but can't compare for example what is the increase/decrease between 2022-09-30 and 2022-09-01.