Accumulated

[jhodasoft]

Good afternoon!, The idea is to get the accumulated from the MIN column and I can't get it. Can someone help me?

file project:

https://drive.google.com/file/d/1VJQDElOSWSJwy_MDY2XD-yMJ0TwtXv5Y/view?usp=share_link

[PiEye]

Hi, I wasn't able to open the file by zipping it, but I was able to recreate the scenario with different data.

You would be best off using a "window" function (see guidance here from SQL BI) 

If I have a function called "min price" and a table ordered by Date, the cumulative min price would look like:

Cumu min price = 
SumX (
    WINDOW (
        0, ABS,
         0, REL,
        ORDERBY ('Sales'[DateKey], ASC )
    ),
    [min price]
)

HTH - if not, see if you can re-attach the pbix and I can try it in your data

Pi Eye

[jhodasoft]

Hi @PiEye , Thanks for answering, I uploaded the file again and this is the new link:

https://drive.google.com/file/d/1xF2Iqwvg8aghLoHxAXcI_QnyDAueqiY-/view?usp=share_link

I also attached an image with the version of Power BI that I am using.