Forum Discussion
Calculated Columns offset value
Good day I am current try to replicate a totalizer reconstructure into power bi using a calculated column. Lets say we have a column named Tagvalues which hold a list of values. I have created a...
Bokangmaela , If you want a new column
Previous Tage value = maxx(filter(Table, [Index] = earlier([Index]) -1), [Tag Value])
for measure consider Offset
Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U
Hello amitchandak ,
I have similiar problem,
1. I get RANK
2. Apply Earlier
it seems ok on 1 single key, but total is not correct. Do you know where it went wrong? 😞