Datesinperiod not working as expected?

[Anonymous]

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],
                        LASTDATE(DateDimension[Date]),-1,Year
                       )
         )

Also side note, if anybody knows how to make this divide by number of entries correctly that would be appreciated, right now i'm just dividing the total by 12 in another measure. it's dirty but I needed to get it working 😞

[Greg_Deckler]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous · Accepted solution]

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