Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone,
Would like to have the new added rows display in my Power BI Matrix table to calculate the EOH Quantity, the logic is a little bit complicated, please check below detailed requirement. What I need in the end is to implement it in Power BI report.
Hope the experts can help on this, it will save my day. Thank you.
Requirement:
Yellow rows are the expected to-be-generated views in my PBI report
Here is my PBI file: (It seems I cannot attach the pbi file directly, please let me know if you can open it.)
https://drive.google.com/file/d/1PWoOq2Y2iP45ykuD5CnP5lD_dAIMFrYi/view?usp=sharing
Excel sample result calculation:
Cheers
Marry
Your pbi file is not useful as the Source refers to a file in your personal workspace, which is not accessible.
Hi @ronrsnfld ,
I put the excel source file here,
My current PBI Matirx table look like below:
My PBI Source data: (Please get the data from above excel which I provided in the google drive)
Cheers,
Marry