Forum Discussion

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