Forum Discussion

Abhijsrwala1's avatar
Abhijsrwala1
Frequent Visitor
4 years ago
Solved

SampePeriodLastYear Help

 

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

  • Anonymous's avatar
    Anonymous
    4 years ago

    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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.