Displaying same period last month from timestamp column not connected to the date table

[bjorneev]

I have a model contaning energy measurements on a 15-minute timestamp level, date dimension and time dimension. What I am want to do is displaying the values in this fashion:

The page is sliced by month from the date dimension, but the timestamp values on the x-axis here is from the fact table.

The problem is that I also want to show last months values on top of this month values. But when I use formulas such as parallelperiod(), dateinperiod(), or dateadd() to get last months values, timestamp values will show for that parallelperiod.

Any tricks to manage this?

Link to .pbix: https://www.dropbox.com/s/ewh6a027fiuou75/Model.pbix?dl=0

Thanks!

[amitchandak]

@bjorneev , have tried a trailing measure like example

Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))