Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
9 years ago

Error in SAMEPERIODLASTYEAR

When adding the following measure:   valor_líquido_ano_anterior = CALCULATE(SUM('order'[valor_líquido]);SAMEPERIODLASTYEAR('calendário'[data])) to the matrix:   I get the error:   ...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

what is your data type?

  • webportal's avatar
    webportal
    Icon for Impactful Individual rankImpactful Individual
    9 years ago

    The date is field is "Date" type and the measure is "Decimal Number".

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      9 years ago

      webportal

       

      i think the issue might be the bidirectional relationship, if you change it to single, does it still give you teh same issue?

      • webportal's avatar
        webportal
        Icon for Impactful Individual rankImpactful Individual
        9 years ago

        vanessafvg same error, single or bi-directional.