Duplicate Date error when dealing with Minutes instead of Days?

[mlapu]

Hello,

I am trying to use measures to find the standard deviations and averages of data that is reported every 15 minutes based on the previous month. The format for the date column "Timestamp" is Date/Time

In previous projects where the data wasn't reported every 15 minutes, I used the dates to filter my data to perform the calculations. With this data, it doesn't seem to work the same way: 

IndA DP Average = 
CALCULATE(AVERAGE(MACT_15MIN_AVG[A108DC01DIFF_PRES15MN_AVG_VAL0]),PREVIOUSMONTH(MACT_15MIN_AVG[timestamp]))

I have tried a few things, but nothing I do seems to bypass this error. As far as I can tell, there aren't any duplicates in the date column- the time changes with each row.

[amitchandak]

@mlapu ,For time intelligence always use a date table and join it with the date of your table without a timestamp

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw