Previous Year Measures not working.

[Anonymous]

Hi!

I have a problem. From one moment to other, measures that were working properly are not working anymore, and I can't figure out why.

The measures are of type DATEADD. Measures that show me sales of previous year, are not displaying values anymore. I have VentasUSD Measure (Period Sales) and VentasUSDAA (Previous Period Sales), witch is calculated using DATEADD function.

The Measure VentasUSDAA =
CALCULATE(
 CALCULATE(
  SUM(
   'Ventas'[USD]
  ) / 1000;
  DATEADD(
   Fecha[Fecha];-1;YEAR
  )
 );
 USERELATIONSHIP(
  'Ventas'[IdFecha];
  'Fecha'[IdFecha]
 )
)

The measures are in "Ventas" table that is related to "Fecha" table (Dates). In the report I have a slicer to select the desired period. And liked I say, the sales of selected period are working just fine, but the column were the "VentasUSDAA" (Previous Year Sales) is, is not displaying any values. The formula has not changed. It was working just fine hours ago and now it's not working.

Thanks in advance.

[Anonymous · Accepted solution]

It has been solved. It was a relationship problem.

Thanks anyway.