Forum Discussion

seenai's avatar
seenai
Icon for Helper II rankHelper II
7 years ago
Solved

Claculated column resulting blank values

Hi,

 

I have added a calculated column 'LY'. But it is giving the blank values.

(Note : I have made a MEASURE in the same way, which is working. But I need a column) 

Formula used is
LY = CALCULATE(SUM(KPI_MfgExp[Actual]),PREVIOUSYEAR(KPI_MfgExp[Month]))

Please let me know, if any modification to be done.

Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi seenai ,

    The time intelligence function PREVIOUSYEAR() requires a continous date column, I would suggest you creating another calendar table with the CALENDARAUTO() function.

    Best Regards,

    Teige

2 Replies

  • yelsherif's avatar
    yelsherif
    Icon for Resolver IV rankResolver IV
    7 years ago

    The scope of this column function is the current row, you probably will not get a return value from current row.

    Instead, you can create a variable that calculates the needed value as follows (this is an experiment!)
    LY =
    var theCalculation = CALCULATE(SUM(KPI_MfgExp[Actual]),PREVIOUSYEAR(KPI_MfgExp[Month]))

    return LY

     

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi seenai ,

    The time intelligence function PREVIOUSYEAR() requires a continous date column, I would suggest you creating another calendar table with the CALENDARAUTO() function.

    Best Regards,

    Teige