Forum Discussion
Solved
Adding a custom 'MAXIFS' column on a calculated table
Hi I have a calculated table in my model which contains the dates from another table. Within that table is a week number which looks at the MAX date in the table and then counts back 7 days. The 7 b...
Hi
Are you trying to show the EOW date?
Column = MOD([Date]-1, 7) + 6
You might need to change the -1 to a different number depending on your week date.
Also, check out date functions in Power Query. There are a tonne to sort out this sort of prob!
https://docs.microsoft.com/en-us/powerquery-m/date-functions
Hi User7664
Try it
Column = VAR CurWeek = ABS('Table'[Week Number]) RETURN MAXX(FILTER('Table',ABS('Table'[Week Number])= CurWeek),'Table'[Date])
