Forum Discussion

sousahebert's avatar
sousahebert
Frequent Visitor
8 years ago

Get data from same weekday from last month

Hi,   I'd like to know how to get values from same period in last month.  For exampe:   Data                Value 02/01/2018 (2th Month Weekday) -  100 04/12/2018 (2th Month Weekday) -  110 0...
ccakjcrx's avatar
ccakjcrx
Icon for Resolver I rankResolver I
8 years ago

Hey sousahebert!

 

I may not be understanding you correctly, but here is what I came up with based on how I understood your problem. 

 

 

Here is the measure: 

 

MsrValueLastMonth = 
CALCULATE(SUM(Sheet1[Value]),
PREVIOUSMONTH(Sheet1[Date])
)

Hope that helps. If not, leave a comment indicating that is the case.

sousahebert's avatar
sousahebert
Frequent Visitor
8 years ago

i'v already tryied it.. but don't worked.....

 

using previousmont or dateadd(date,-1,month) , the result is:

 

Date             M0     M-1

 

04/12/2017  110   

05/12/2017  240    

02/01/2018 100     5000

03/01/2018  200    5000

 

its return the full last month value (5000 its the value between 01/12/2017 and 31/12/2017)....

  • ccakjcrx's avatar
    ccakjcrx
    Icon for Resolver I rankResolver I
    8 years ago

    Hey sousahebert!

     

    Is there any way you can post your .pbix file? If you've never done that before, you can post your file to either OneDrive or Google Drive, and then post the link to that file here. 

      • v-jianhe-msft's avatar
        v-jianhe-msft
        Icon for Resolver II rankResolver II
        8 years ago

        Hi，

         

        Forgive me but I am a bit confused about your business logic.

        Referring to your second time reply:

         

        >>> Date         M0     M-1

         

         

        04/12/2017  110  

         

        05/12/2017  240   

         

        02/01/2018 100     5000

         

        03/01/2018  200    5000

         

        >>> its return the full last month value (5000 its the value between 01/12/2017 and 31/12/2017)....

         

        So,

        1. here, “04/12/2017” means “2017 December 4th”,  “02/01/2018” means “2018 January 1st”, right?
        2. And you want to make “M-1” for “02/01/2018” to be 110, similarly, “M-1” for “03/01/2018” to be 240, right?

         

        If so, but what is the relationship between “04/12/2017” and “02/01/2018”?

        “2017 December 04” is Monday, while “2018 January 02” is Tuesday, so they are not the same weekday. Obviously, they are not the same workday in two months?

         

        Also, but what is the relationship between “05/12/2017” and “03/01/2018”?

        “2017 December 05” is Tuesday, while “2018 January 03” is Wednesday, so they are not the same weekday. Obviously, they are not the same workday in two months?

         

        So how do you want to match the data between this month’s date and previous month’s date?

         

        Best Regards,

        Henry