Forum Discussion

New_be's avatar
New_be
Helper V
3 years ago

Hi Ahmedx ,

Thank you for your sharing. I learn new things today. 😊
But in my case this didn't work since my table have multiple employee for 1 date:

Below is my measure for the offset:

 

 

When I tried, an error message popup "offset relation parameter contains column "DateStamp" which matches more than one row or filter context". Is the issue happen because of that? Thank you for your help 🙏🏻

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    are you trying to create a calculated column?

    • New_be's avatar
      New_be
      Helper V
      3 years ago

      Hi Ahmedx,
      No, the image i attached is measure.. I tried to copy from what you did in your pbix file that I downloaded..

      • Ahmedx's avatar
        Ahmedx
        Super User
        3 years ago

        Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).