Forum Discussion

DLimerick's avatar
DLimerick
Regular Visitor
8 years ago

Comparing data by week and the same week number from a previous year.

I have a table in PBI with date annd have extracted the year and week number for each date into separate columns. I can graph my data which counts all created records by week and I have a slicer tha...
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi DLimerick

"Calculation error in measure. a date column cntaining duplicate dates was specified in the call to function'SAMEPERIODLASTYEAR'. This is not supported."

The date column in your dataset contains duplicate values, for example, there are two rows of 2018/1/2, right?

 

Best Regards

Maggie


 

yacatac's avatar
yacatac
Frequent Visitor
7 years ago

Hi,

 

I'd like to restart this thread as I have this exact issue. We would have multiple dates in the source data. However, our periods are 4/4/5 and would like to compare prior week, prior year week, and prior year YTD (by week).

 

Would this be possible?

 

TIA,

Stuart

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi yacatac

    Please open another post so more people may see and more solutions will be provided.

     

    Best Regards

    Maggie

    • yacatac's avatar
      yacatac
      Frequent Visitor
      7 years ago

      Will do, however the original post hadn't been solved, so I thought other people who have the same issue wouldn't want to trawl through numerous posts to get an answer.