Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Datesinperiod not working as expected?

Why would 1 day in the same month suddenly remove a full month from below measure?   Rolling PTLIQ = CALCULATE(SUM('NetSuite_P&L_Monthly'[Monthly PTLIQ]), DATESINPERIOD(DateDimension[Date], ...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hey Greg, your code was a little too much for me. I went with something simpler that seems to give me the results I need.

     

     
    Rolling PTLIQ = 

CALCULATE(SUM('NetSuite_P&L_Monthly'[Monthly PTLIQ]), DATESINPERIOD(DateDimension[Date],
                        LASTDATE(PREVIOUSDAY(PREVIOUSMONTH(DateDimension[Date]))),-1,Year
                       )
         )
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey Greg, your code was a little too much for me. I went with something simpler that seems to give me the results I need.

     

     
    Rolling PTLIQ = 

CALCULATE(SUM('NetSuite_P&L_Monthly'[Monthly PTLIQ]), DATESINPERIOD(DateDimension[Date],
                        LASTDATE(PREVIOUSDAY(PREVIOUSMONTH(DateDimension[Date]))),-1,Year
                       )
         )