Forum Discussion
Split a column based on category
Hello! I just uploaded this question but i didn't label it correctly and I think it got lost in the flow. I have a table that looks like this: The price of something will be (one of the ...
Anonymous Where does price measure come from please? You may need to use a CROSSJOIN to get all options or split your data into two unrelated tables - one table for HRR and another table for Turn. Each table should have the Product Code and the option (HRR or TURN). Then you'll relate these to the DimProduct table and you should be able to create a visual using your already existing [Price Measure] (depending on how that's calculated).
Can you paste sample data as a table format (raw data, as separate tables if that's how they come in, and including the price)