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...
sousahebert's avatar
sousahebert
Frequent Visitor
8 years ago

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 Workday) - 100

04/12/2018 (2th Month Workday) - 110

03/01/2018 (3th Month Workday) -200

05/12/2018 (3th Month Workday) -240

I need the data like this

 

Data M0 Previous Month

02/01/2018 100 110

03/01/2018 200 240

 

Is it possible?

 

Tks

 

 

  • ccakjcrx's avatar
    ccakjcrx
    Resolver 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
        Resolver 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.