topic Datesinperiod not working as expected? in DAX Commands and Tips

Datesinperiod not working as expected?

Anonymous — Sat, 31 Aug 2019 02:13:39 GMT

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 :(

Re: Datesinperiod not working as expected?

Greg_Deckler — Sun, 01 Sep 2019 12:03:38 GMT

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-TITHW/m-p/434008

Re: Datesinperiod not working as expected?

Anonymous — Sun, 01 Sep 2019 22:37:54 GMT

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