topic Re: Accumulated in DAX Commands and Tips

Accumulated

jhodasoft — Mon, 17 Apr 2023 21:29:00 GMT

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:

PiEye — Tue, 18 Apr 2023 07:50:05 GMT

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 — Tue, 18 Apr 2023 20:55:01 GMT

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

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