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 = CALCU...
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

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