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).

      • New_be's avatar
        New_be
        Helper V
        3 years ago

        I created a simple pbix and I tested your code. Your code is 100% is working! 😊

        But, in the real data that I have, when "DATEDIFF([Max date], [Gap in date],DAY) + 0" code makes my visual table weird. If only "DATEDIFF([Max date], [Gap in date],DAY)" its work. See below image:

        I have filter outside visual which is EmpNo = 18161 and YearMonth = Y23M05. When I used  "DATEDIFF([Max date], [Gap in date],DAY) + 0", it ignore the filter outside. This is the only issue that i have left.

        Relationship & measure:

        Filter EmpNo that I filter outside coming from table profile & occupation.


        Thanks again for your assistance. Appreciate it