Creating a new data

[altemural]

I have two different type datas. I need to create a new graphic by finding the new value between two of them. New table = Whole Sales - Retail.

[Icey]

Hi @altemural ,

Please check if this is what you want:

1. Add an Index column in Power Query.

2. Create a measure.

Measure =
VAR RetailIndex =
    MAX ( 'Table'[Index] ) - 12
VAR WholeSalesValue =
    CALCULATE (
        MAX ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Index] = RetailIndex )
    )
RETURN
    IF (
        MAX ( 'Table'[Type] ) = "Retail",
        MAX ( 'Table'[Value] ) - WholeSalesValue
    )

3. Create a Pie chart or other visuals.

For details, please check the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener · Accepted solution]

Hi @altemural ,

i would create Measures.

Retail = CALCULATE(SUM('Table'[Value]), 'Table'[Type] = "Retail")

Whole Sales = CALCULATE(SUM('Table'[Value]),'Table'[Type] = "Whole Sales")

Other Sales = [Whole Sales] - [Retail]

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.