Forum Discussion

pedrogpg's avatar
pedrogpg
New Member
4 years ago

Filtering between 2 fact and 2 dimension tables

Hi everybody   I haver the following scheme where: Relação de Clientes = Customer Base (dimension) Cód_Item = Item Base (dimension) dCalendário = Calendar (dimension) fEmpenho = Open Orders (fa...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

pedrogpg , Based on what I got , Try like

 

CALCULATE(AverageX(values(dCalendario[Month Year]), calculate(SUM(fNFe[Quantidade]))),DATESINPERIOD(dCalendario[DataBase], eomonth(Max(dCalendario[DataBase]),0),-3,MONTH))


CALCULATE(AverageX(values(dCalendario[Month Year]), calculate(SUM(fNFe[Quantidade]))),DATESINPERIOD(dCalendario[DataBase], eomonth(Max(dCalendario[DataBase]),0),-6,MONTH))

pedrogpg's avatar
pedrogpg
New Member
4 years ago

Hi amitchandak 

Thanks for your reply.

The average measures are working perfectly.

The problem is with the measure 

Qtd mês anterior = CALCULATE(SUM(fNFe[Quantidade]),PREVIOUSMONTH(dCalendario[DataBase]))