Forum Discussion
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 ...
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.
Hi Kazu ,
You are on the right track with OFFSET. Here is a video with more information:
https://www.youtube.com/watch?v=BRZrC3stCEQ
Thanks. I am trying OFFSET and I feel it would work if the number of repeat in my example is fixed but not if variable.