Relationship between tables

[abelrmg]

Hello,

I have 4 four tables:

1. Invoicing

2. Date table

3. Accounts receivable

4. Attribute

This is the relation:

The visualization is this:

The formula Ventas-1 doesn't work when i select a filter for department (LN01,LN02).

The formula is:

Ventas-1 = CALCULATE([Ventas]|PARALLELPERIOD(Dates[Date]|-1|month))

Ventas = SUM(RMG_AXFACTCUSTINVOICING[LINEAMOUNTMST])

The result is this:

Don't show info for Ventas-1 in all months only when the other table have a data. But if a disable the relationship betwen Departamento table with the other transaciont tables works fine.

Any ideas how can I do this arrangement?

Regards

[abelrmg · Accepted solution]

Hello, thanks to everyone the error is this relationship:

I configured it as a single way and works fine.

Regards

[aj1973]

good Job

[amitchandak]

@abelrmg , Try a trailing measure

Ventas-1 = CALCULATE([Ventas],dateadd('Date'[Date],-1,Month))

[abelrmg]

@amitchandak , when I apply the filter for table Departamento usign the forumula  that you proposed to me the visual mark error: the DATEADD function expects continuous selection....

Regards

[aj1973]

@abelrmg 

try to make the relationship between tables go both way for all of them and see how it works out!

[abelrmg]

@aj1973 , does not allow me to configure relationships in both way it sends an ambiguity error and i should delete a relationship

Regards