Forum Discussion
Max() value of field
In Power Query language (M) there is List.Max and Table.Max:
https://msdn.microsoft.com/en-us/library/mt260763.aspx
In DAX, you could create a measure and use the MAX function:
https://support.office.com/en-US/article/MAX-Function-DAX-79baa07f-5b6c-4cec-a372-b1ea60e33574
List.Max(Sales_Line_Archive[Version No_]) fixed it. I had to remove all duplicate values
In Power Query language (M) there is List.Max and Table.Max:
https://msdn.microsoft.com/en-us/library/mt260763.aspx
In DAX, you could create a measure and use the MAX function:
https://support.office.com/en-US/article/MAX-Function-DAX-79baa07f-5b6c-4cec-a372-b1ea60e33574
List.Max(Sales_Line_Archive[Version No_]) fixed it. I had to remove all duplicate values
How do I set a max function so that each row returns the Max Value of the past X days? (I.e. For a row labeled March 27th, the cell will return the largest value between 3/8 and 3/27, March 28th would return the largest value between 3/9 and 3/28, etc.)
