Forum Discussion

edavila's avatar
edavila
Helper II
7 years ago

Quick Measure YoY%

Hello Community   I seeking for help as I have a formula that is not working correctly  I had the same formula with another table and it was working correctly but I remapped and everything is the ...
Show and Tell
Tutorial Requests
MFelix's avatar
MFelix
Super User
7 years ago

Hi edavila ,

 

What this error means is that the column you are using on the measure to calculate the SAMEPERIODLASTYEAR is coming from a table that doesn't have continuous dates.

 

Are you using a calendar table to make the calculation or only a column with fact data?

 

You need to have a column that starts on january 1st and ends on 31st December, this need to be within several years period.

 

Regards,

MFelix

  • edavila's avatar
    edavila
    Helper II
    7 years ago
    Thank you for your answer and yes the date calendar table I use a filter that is “after 12/31/2015” is this wrong
    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi edavila 

      Is this problem sloved? 

      If it is sloved, could you kindly accept it as a solution to close this case?

      If not, please let me know.

       

      Best Regards

      Maggie