Transformation and relation

[dr_anas]

Can someone please join me virtually to help me with my project? I need assistance fixing the transformation because my relationship isn't working. and I have a historical sales report with many fields like the supplier's name, item code, item description, selling price, quantities, invoice date, and some other information. TIA

[vanessafvg]

can you provide sample data in a usable format, or your pbix either with examples of your expected outcome?