Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

MTD calculated column

Hi,   I have source data amounts presented in year-to-date (IBM Cognos) and are trying to create a calculated column in the fact table that is presenting the month-to-date value. Example below:   ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , A new column

 

New column =
[YTD] = maxx(filter(Table, [Date] = earlier([Date])-1 && [Account] = earlier([Account] )
&& [DIM1] = earlier([DIM1] )
&& [DIM2] = earlier([DIM2] ) ),[YTD])

 

 

Add and remove equal joins as per need