Forum Discussion

Kazu's avatar
Kazu
Icon for Helper II rankHelper II
10 months ago
Solved

Duplicate, shift, then aggregate

Suppose there is Base Table like below I would like an output table like the left side of below.  Repeat and Offset are variables or could be parameters in Power BI. Not sure "Offset" is the ...
  • v-saisrao-msft's avatar
    v-saisrao-msft
    10 months ago

    Hi Kazu,

    By utilizing the DAX function GENERATE along with a parameter table or offset table, you can dynamically control the offset value. Please use the following DAX as a calculated table to achieve the desired outcome.

    OutputTable =
    GENERATE(
        'Base',
        ADDCOLUMNS(
            'OffsetTable',
            "ShiftedIndex", 'Base'[Index] + 'OffsetTable'[OffsetValue],
            "ShiftedValue", 'Base'[Value]
        )
    )

     

     

    Thank you.

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
10 months ago

Hi Kazu,

By utilizing the DAX function GENERATE along with a parameter table or offset table, you can dynamically control the offset value. Please use the following DAX as a calculated table to achieve the desired outcome.

OutputTable =
GENERATE(
    'Base',
    ADDCOLUMNS(
        'OffsetTable',
        "ShiftedIndex", 'Base'[Index] + 'OffsetTable'[OffsetValue],
        "ShiftedValue", 'Base'[Value]
    )
)

 

 

Thank you.