Last Year to date measure not when I selecting filter.

[Anonymous]

Hello, 

I have calculated LYTD sales in two different ways, but When I filtered down by a vendor or Manufacture it does not show LYTD sales. Can anybody please tell me what wrong with my method? 

Thank you so much

[Interkoubess · Accepted solution]

Hi @Anonymous,

It won't work because you did not use a calendar table for your calculations.

Pleate create a calendar table with continuous day and link it to your fact model then process, it will work.

Ninter

[Interkoubess · Accepted solution]

Hi @Anonymous,

It won't work because you did not use a calendar table for your calculations.

Pleate create a calendar table with continuous day and link it to your fact model then process, it will work.

Ninter

[Interkoubess · Accepted solution]

Hi @Anonymous,

This is what I was talking about :

https://drive.google.com/file/d/1NK1xeEJT8tE1KmBEPXY2l8GeAsxWTVHG/view?usp=sharing

Hope it helps...

Ninter

[Anonymous]

@Interkoubess

Thank you so much. That works. I really appreciate your help.