SampePeriodLastYear Help

[Abhijsrwala1]

I don't know what's wrong here.I see blanks for values.I think I am missing something.

[SanketBhagwat]

Hi @Abhijsrwala1 .

Check to see if you have data for those date in the data view.

Filter the CY for that date and see if you see the summarized daat for that date.

Thanks,
Sanket

If this post helps, then mark it as 'Accept as Answer' and give it a thumbs up.

[Abhijsrwala1]

I have data for the dates.

[SanketBhagwat]

In your case,as per your date selection i.e. 10th Jan 2019, you should have a data for 10th Jan 2018.

What I mean to say is that any date you are selecting should have the data for the same date but for the last year.

See if you have data for 10th Jan 2018.

[Abhijsrwala1]

How to get last year same month.

[Anonymous · Accepted solution]

Hi @Abhijsrwala1 ,

You need a calendar table.

CALENDAR = CALENDAR(MIN('FACT SOPO'[Date]),MAX('FACT SOPO'[Date]))

Relationships.

Try this measure.

Qty N-1 = CALCULATE([Measure],DATEADD('CALENDAR'[Date],-12,MONTH))

Attached PBIX file for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Abhijsrwala1]

How to get last year same month.