Complex data calculation with IF and SUM conditions

Hey Anonymous ,

here you will find a pbix file

https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EVjLF2yiqXBCog3wEtfmdQABEMm03Fk7ejCH7DDCRTVIzw?e=f3NISa

that contains a sample implementation using Power Query.

If you look at the steps on the right (the first two steps have been added automatically by copying the data you provided to an empty table), this is what happens:

Here is a screenshot that shows a simple table visual:

Hopefully, this helps to tackle your challenge.

Regards,

Tom