Forum Discussion
Kazu
Helper II
Helper IIDuplicate, 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 ...
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
Community Support
Community SupportHi Kazu,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.