I am trying to get the monthnumber and the offset number in the calculated table.
Januari being 1
February being 2
March 3 etc
Same goes for the month offset
If I remove MAXX I get an error because there is no single value for the column.
@Diabolica ADDCOLUMNS only has Row Context and and it’s first argument doesn’t apply a Filter Context to the DateTable in the MAXX, Wrap MAXX inside CALCULATE.
1 Like