Max() value of field

[MarkusHoffmann]

Hi everyone,

I'm new to Power BI and i'm migrating a NAV based QlikView application to Power BI.

Probably a simple question, but how can I calculate the max value of a field within the data load process (after querying the data from the DB)?

Thanks in advance!

[Greg_Deckler · Accepted solution]

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

[Greg_Deckler · Accepted solution]

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

[MarkusHoffmann · Accepted solution]

List.Max(Sales_Line_Archive[Version No_]) fixed it. I had to remove all duplicate values

[MBrown]

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