Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 😞
Solved! Go to 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 ) )
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...
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 ) )
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |