Calculating Total Net Sales for Checks that contain an Item

[Anonymous]

Hey guys,

I'm trying to calculate the TOTAL Net Sales for CheckIDs that Contain an Item. I have an Item table and Sales table linked on Item ID.

Thanks

[v-yuta-msft]

HI jeremy808,

Could you share some sample data and clarify more details?

Regards,

Jimmy Tao

[TomMartens]

Hey,

it's difficult to provide an answer that will meet your requirements you have to provide more information, like:

do you want to create a calculated column or measure:

• https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns
• https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

And please consider to prepare some sample data, using an Excel file, using one sheet per table and upload the file to onedrive or dropbox.

Regards,

Tom