Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Move Calculated Column value ahead in time?

Hi guys, i need help moving my calculated column calculation value (can be a measured if needed) into month ahead of it. The image below should make things clear. Instead of having my target li...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    You may refer to the following code.

    Column =
IF (
    CALCULATE (
        SUM ( 'Data Table'[Actual] ),
        PREVIOUSMONTH ( 'Data Table'[Fiscal Dates] )
    )
        <> BLANK (),
    'Data Table'[Planned]
        + CALCULATE (
            SUM ( 'Data Table'[Planned] ) - SUM ( 'Data Table'[Actual] ),
            PREVIOUSMONTH ( 'Data Table'[Fiscal Dates] )
        )
)
ryan_mayu's avatar
ryan_mayu
Super User
7 years ago

Anonymous

 

I only see 0 value for Mar and Apr in your example. Could you please let me know what is the result you expected. You can just give a simple example in excel file.

 

Are you trying to move the target value one month earlier?

Column = CALCULATE(SUM('Data Table'[Target]),DATEADD('Data Table'[Fiscal Dates],1,MONTH))