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])
No, im not trying to find the end of the week. The end of the week will always be the last day in the query that this table is generated from. The End of the week can often be a tuesday or a thursday. The -1 indicates all the days part of that week, and the -2 are all the days part of the 2nd week back. I just need to know what the last day in -1 is and the last day in -2 is etc.