Select fields based on category in a table with DAX calculation

Question

Hello,&nbsp;Is it possible to use a specific field based on what the dimension is?Like the example below:What I have:&nbsp;What I am looking for:&nbsp;I cannot merge the two columns in the Power Query - it has to be done with DAX.&nbsp;Thank you 🙂&nbsp;&nbsp;

mfelix · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Try to add a new table with the following code:
Table 2 =
UNION (
    SELECTCOLUMNS (
        FILTER ( 'Table', 'Table'[Customer] &lt;&gt; BLANK () ),
        "Customer/Product", 'Table'[Customer],
        "Dimension", 'Table'[Dimension]
    ),
    SELECTCOLUMNS (
        FILTER ( 'Table', 'Table'[Product] &lt;&gt; BLANK () ),
        "Customer/Product", 'Table'[Product],
        "Dimension", 'Table'[Dimension]
    )
)
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Select fields based on category in a table with DAX calculation

Related content

MAPE calculation with multiple categories selected in a filter

Quarter calculation upto selected month

I want to calculate Aging category based on date selection

Calculate Average per category

Change in category selection changes selected subcategory in slicers