Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jhodasoft
Frequent Visitor

Accumulated

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

jhodasoft_0-1681765934370.png

file project:

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

2 REPLIES 2
PiEye
Resolver II
Resolver II

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

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.

jhodasoft_0-1681851272289.png

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.