Help with Incorporating a Field into Formula

Super User

1 year ago

Thank you Anonymous for the example data.

You description is very vague but I can clearly see that your data does not have a Start Schema.

The data has 2 many to many releationships and a circular reference.

If we attempt to fix your current problem then you likely to encounter other problems elsewhere.

Please learn how to use Power Query to reshape your data into a Start Schema here:-

Also watch you tube videos.

Sorry, if this answer seems unhelpful but I have correctly identified the problem and the solution.

Sadly I dont know your bussiess or field names meaning and cant offer any more help with such a vague problem description.

Please accept the solution and click thumbs up. Thank you

Forum Discussion