Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.