I am having a problem with calculating a Min and Max. The scenario is as follows.
I have a column SKU and a column Price. I only want to get a Min and Max value if the SKU column has a value. The reason for this is because the data I am working with has shipping costs as a value in the Price column, but doesn't have an value in the SKU column.
Clearly, I don't want to include these shipping costs as a min or max because I only want to include products in the Min/Max.
Does anyone know how I can structure a DAX to accomplish this?