The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear Power BI gurus, I am stuck on this calculation, any help will be greatly appreciated.
I am attaching the scheme with the expected results. If any clarifications are needed, shout!
@airportGR , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check if these can help
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Appreciate your Kudos.
@amitchandak Unfortunately, the page does not allow me to upload a .pbix
Uploading from my OneDrive, please download using the link.
shorturl.at/BGJV2
I hope that now it is clear what i am after.