Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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]
)
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.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
12 | |
10 | |
6 |